Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
With VLOOKUP I can look in the first column of an array and moves across the
row to return the value of a cell. But what I need is a function that moves across the row and returns all the values that coincide with the first row. For example a recipe has different ingredients, what I need is a way to type in the product code and that excel deliver all the ingredients common to the code. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Vlookup Syntax Error | New Users to Excel | |||
VLOOKUP not working | Excel Worksheet Functions |