Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup Help
Hi All, I have a key value (aaa, bbb below) that I want to bring back an
array of values. Using VLookup I can get the first value, but I now want to use the value it returns to find the next value and so on... I have a table with a key value (aaa for example); Col-A Col-B aaa aaa fred aaa aaa tom aaa aaa rachel aaa ... bbb bbb I want the formula that will return something like this... aaa (hard coded typed in value) aaa fred (position 1 based on above value) aaa tom (position 2 based on aaa fred, grabbing 1 row below) aaa rachel etc. I'm not even really sure how to tackle this, so any suggestions would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |