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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup for Column b
If you want to bring back a value that's in a column to the right of column B,
you can still use =vlookup(). =vlookup(1,b1:o10,2,false) will bring back the value in column C if there's a match. If you wanted to bring back any column (including column A), you could use =index(match()): =index(a1:a10,match(1,b1:b10,0)) to bring back a value from column A or =index(x1:x10,match(1,b1:b10,0)) to bring back a value from column X Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble nataliemarylang8 wrote: 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 -- Dave Peterson |
Reply |
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 |