Hi
I am trying to write a forumla which will look at a range that might look like this:
A
B
C
I am need it to return:
A
B
C
So I want it to lookup to see if there is a value, if so return the cell in the range if not move on until it finds a value. I know I can do it with a macro but I am trying to avoid using macros if possible.
Or even better, I am using the formula =INDEX($B2:$I6,MATCH(14,$H2:$H6,0),2), I want it to take the data from any match for '14' and then the next row for the next value of 14 and so on.
Thanks for your help,
Sam
Bookmarks