vlookup
Hi
Assuming that you have a dataset as follow :
Col A--------Col B-------Col C-------Col D
Name-------Value-------Lookup-----Value Return
Alan--------100-----------Ken--------300
Joey--------200
Ken---------300
Mike--------400
and you want to find the corresponding value for Ken in col A and have
the result in D2.
=VLOOKUP("Ken",A5:B9,2,0)
Alternatively, you may want to use cell to hold the lookup value, eg
C2 hold the lookup value, ie Ken
=VLOOKUP(C2,A5:B9,2,0)
This will give you 300 in D2
I suggest that you post your problem with an example if there is one you
are currently facing with.
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"nader" wrote:
hi
please give me an example of vlookup function
regards
nader
|