Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I use "=VLOOKUP($B$4,Sheet1!$G$2:$W$137,17,FALSE)" to find cells in column
"G" in "Sheet1" that contains the same value as in "B4" and return the value in column "W" in "Sheet1". My problem is that the numbers in column "W" are unique but not the numbers in column "G". In the next cell I want to do the same and also look for another cell in Column "G" in "Sheet1" with the same value as in "B4", but I will always get the first found result. I want to look for the next cell in column "G" in "Sheet1" that contains the same value as in "B4" but with another value in Column "W" than the first found. Is my question clear? Probably not, but I would very much appreciate if some one could help me. /Confused |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Unique Values | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
How do I return the unique entries from a column to a listbox | Excel Worksheet Functions |