Author Topic: How do I use the VLOOKUP function  (Read 922 times)

Offline mubashir

  • Newbie
  • *
  • Posts: 22
  • Reputation: -1478
How do I use the VLOOKUP function
« 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

Offline hmh

  • SF Geek
  • ****
  • Posts: 347
  • Reputation: 163
Re: How do I use the VLOOKUP function
« Reply #1 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.
Help Yourself! And Everyone gets involved to take you to your destination!!

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: How do I use the VLOOKUP function
« Reply #2 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!
« Last Edit: April 27, 2010, 01:33:11 pm by Nobody »
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.