| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup for Column b
I have a very complicated exercise but I am changing it around so it is easier
What I have been using is the formula =VLOOKUP(1,A1:O10, 2, FALSE) This is looking up 1 in column a What I want to do is be able to look up say 1 in column b How would I do this Also this is for a list of values would I be able to put a cell reference say b2 instead of the 1 so I can copy the formula all the way down thanks -- Natalie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup 1st column time 2nd column text | Excel Worksheet Functions | |||
| VLookup - Column name? | Excel Discussion (Misc queries) | |||
| VLOOKUP using Fifth Column | Excel Worksheet Functions | |||
| vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
| VLookup & Column Sum | Excel Worksheet Functions | |||
Threaded Mode
