|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 29th, 2009, 07:47 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
how to calculate the v-lookup formula
Please forward the formula
Thanks for all of them Salman 
|
|
#2
March 29th, 2009, 10:01 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to calculate the v-lookup formula
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
|
|
#3
March 29th, 2009, 10:09 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to calculate the v-lookup formula
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
|
|
#4
March 29th, 2009, 05:13 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to calculate the v-lookup formula
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
