Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLLOKUP - more than one result??
My range of data (table array) has more than one row that meet the VLOOKUP criteria I have set. I have a VLOOKUP in eg A1 =VLOOKUP($K$1,Order_Log,6,FALSE). In this I want the first value to be returned (as VLOOKUP does per standard, using FALSE). This I can do. In cell A2 however, I would like to return the 2nd value from my range of data. In cell A3, the 3rd ....and so on (only up until around the 6th value). What do I need to add into my A1 formula, for the 2nd value to be returned in A2? I guessed it may be as easy as FALSE +1, but this does not seem to work! Many thanks Jenny -- luvthavodka ------------------------------------------------------------------------ luvthavodka's Profile: http://www.excelforum.com/member.php...o&userid=34856 View this thread: http://www.excelforum.com/showthread...hreadid=546049 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLLOKUP - more than one result??
Hi Jenny,
try to create the same formula on the cell A2, A3, A4, etc changing the 6 before ",FALSE" to &, 8, etc hope it help regards from Brazil Marcelo "luvthavodka" escreveu: My range of data (table array) has more than one row that meet the VLOOKUP criteria I have set. I have a VLOOKUP in eg A1 =VLOOKUP($K$1,Order_Log,6,FALSE). In this I want the first value to be returned (as VLOOKUP does per standard, using FALSE). This I can do. In cell A2 however, I would like to return the 2nd value from my range of data. In cell A3, the 3rd ....and so on (only up until around the 6th value). What do I need to add into my A1 formula, for the 2nd value to be returned in A2? I guessed it may be as easy as FALSE +1, but this does not seem to work! Many thanks Jenny -- luvthavodka ------------------------------------------------------------------------ luvthavodka's Profile: http://www.excelforum.com/member.php...o&userid=34856 View this thread: http://www.excelforum.com/showthread...hreadid=546049 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLLOKUP - more than one result??
What is the range Order_Log refers to?
luvthavodka wrote: My range of data (table array) has more than one row that meet the VLOOKUP criteria I have set. I have a VLOOKUP in eg A1 =VLOOKUP($K$1,Order_Log,6,FALSE). In this I want the first value to be returned (as VLOOKUP does per standard, using FALSE). This I can do. In cell A2 however, I would like to return the 2nd value from my range of data. In cell A3, the 3rd ....and so on (only up until around the 6th value). What do I need to add into my A1 formula, for the 2nd value to be returned in A2? I guessed it may be as easy as FALSE +1, but this does not seem to work! Many thanks Jenny |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLLOKUP - more than one result??
Please read Chips suggestions for new posters and please don't multipost.
http://www.cpearson.com/excel/newposte.htm "luvthavodka" wrote: My range of data (table array) has more than one row that meet the VLOOKUP criteria I have set. I have a VLOOKUP in eg A1 =VLOOKUP($K$1,Order_Log,6,FALSE). In this I want the first value to be returned (as VLOOKUP does per standard, using FALSE). This I can do. In cell A2 however, I would like to return the 2nd value from my range of data. In cell A3, the 3rd ....and so on (only up until around the 6th value). What do I need to add into my A1 formula, for the 2nd value to be returned in A2? I guessed it may be as easy as FALSE +1, but this does not seem to work! Many thanks Jenny -- luvthavodka ------------------------------------------------------------------------ luvthavodka's Profile: http://www.excelforum.com/member.php...o&userid=34856 View this thread: http://www.excelforum.com/showthread...hreadid=546049 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
spell number | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions |