Hi,
I've searched on forums for a few hours but couldn't find a solution for this.
Below is the data I have.
Say I need to get values from Column C. VLOOKUP'ed values return the first value, but i need it to move on to the next result if the first one = 0.
so I will get
123 - not 0, but 0.22
234 - 0.1
345 - 0.
I have the sheet sorted by other fields like I need it to, so I can't change sorting.
Items are not in order as you see, so I can't find the row and move down one.
Please Help!!
THANKS!
I've searched on forums for a few hours but couldn't find a solution for this.
Below is the data I have.
Say I need to get values from Column C. VLOOKUP'ed values return the first value, but i need it to move on to the next result if the first one = 0.
so I will get
123 - not 0, but 0.22
234 - 0.1
345 - 0.
TEST_LOOKUP.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Number | 1 | 2 | 3 | |||||||
2 | 123 | 0.2 | 0 | 0.2 | |||||||
3 | 234 | 0.1 | 0.1 | 0 | |||||||
4 | 345 | 0 | 0 | 0 | |||||||
5 | 123 | 0 | 0.22 | 0 | |||||||
6 | 234 | 0 | 0 | 0.15 | |||||||
7 | 123 | 0.24 | 0.24 | 0.24 | |||||||
8 | |||||||||||
Sheet1 |
I have the sheet sorted by other fields like I need it to, so I can't change sorting.
Items are not in order as you see, so I can't find the row and move down one.
Please Help!!
THANKS!