Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using VLOOKUP function to search through col A to extract data from
col B within the same row. However, there are multiple data in col A, which fulfil the condition defined in VLOOKUP. The function finds only the first cell that fulfills the condition. Is there any way how to repeat/continue VLOOKUP search for next matching value bellow in col A and thus place several extracted values from col B to new a column? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Problem (limitation)? | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |