IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => GCE AS & A2 Level => Queries => Topic started by: mubashir on April 18, 2010, 06:29:28 pm

Title: How do I use the VLOOKUP function
Post by: mubashir on April 18, 2010, 06:29:28 pm

What's supposed to go into table array, col_indx number, bla bla and etc?
I'm doing Q6 on AICT P2 OCT/NOV 2009

Title: Re: How do I use the VLOOKUP function
Post by: hmh on April 18, 2010, 07:04:13 pm

I am nt sure about the paper itself because I take computing not AICT but I can try helping I guess.

Attaching a xls file everything explained.

Title: Re: How do I use the VLOOKUP function
Post by: Nobody on April 27, 2010, 01:16:22 pm

Vlookup_value   B6      because we want value for that particular cell.
table_array...           you know why! :P
col_index_num   3       because we want the names of COMPANY rhich is in thirs coloum!



Also check the print shots attached!