Revolution Now!
Welcome,
Guest
. Please
login
or
register
.
Have you missed your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length.
News:
New servers, hooraaaay! More bandwidth, more power.
Home
Help
Calendar
Login
Register
IGCSE/GCSE/O & A Level/IB/University Student Forum
»
Qualification
»
GCE AS & A2 Level
»
Queries
»
How do I use the VLOOKUP function
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: How do I use the VLOOKUP function (Read 922 times)
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
Logged
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.
Logged
Help Yourself! And Everyone gets involved to take you to your destination!!
Nobody
Global Moderator
SF V.I.P
Posts: 5351
Reputation: 65535
Gender:
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!
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
»
Logged
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.
Print
Pages: [
1
]
Go Up
« previous
next »
IGCSE/GCSE/O & A Level/IB/University Student Forum
»
Qualification
»
GCE AS & A2 Level
»
Queries
»
How do I use the VLOOKUP function