| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup() function
Hi please suggest how to use vlookup() function for the problem given
below to identify the word for given id A B id word 1 tennis 2 hat 3 trial 4 ride 5 complex 2 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup() function
Try
=VLOOKUP(2,A2:B6,2,FALSE) Mike "harsh_njoy" wrote: Hi please suggest how to use vlookup() function for the problem given below to identify the word for given id A B id word 1 tennis 2 hat 3 trial 4 ride 5 complex 2 Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup() function
=VLOOKUP(A10,$A$1:$B$6,2,FALSE) entered in C1
Assumes you typed 2 in A10..............will return hat to C1 Gord Dibben MS Excel MVP On Fri, 25 Jul 2008 07:24:31 -0700 (PDT), harsh_njoy wrote: Hi please suggest how to use vlookup() function for the problem given below to identify the word for given id A B id word 1 tennis 2 hat 3 trial 4 ride 5 complex 2 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Linear Mode
