Please forward the formula

Thanks for all of them


Salman

Dear Salman

Let the data be the below starting from A1
ColA ColB
1 One
2 Two
3 Three

In C1 enter one of the values 1,2,3
D1 enter the formula =VLOOKUP(C1,A1:B3,2,FALSE)

If this post helps click Yes
---------------
Jacob Skaria

"Salman" wrote:

Please forward the formula

Thanks for all of them


Salman

Salman;287733 Wrote:
Please forward the formula

Thanks for all of them


SalmanIf your asking for the structure of a VLOOKUP then its this:
=VLOOKUP(the value to lookup, the range to lookup in, which column the
holds the result in the lookup range, FALSE for exact match or TRUE for
nearest match)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=80388

When all else fails, try the HELP index


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Salman" wrote in message
...
Please forward the formula

Thanks for all of them


Salman