J
Jon Ratzel
I'm trying to figure out how to retrieve a value 1 row below the value that
would normally be retrieved with a regular vlookup. As an example below,
using 1234 as my lookup value, column A-B as the table array, column index
=2, and range lookup ="false" I'd like to return the value "5" instead of
"2". Can this be done somehow through an formula?
COL A COL B
Item # Sales
1234 2
5
3
4
2345 6
7
9
1
would normally be retrieved with a regular vlookup. As an example below,
using 1234 as my lookup value, column A-B as the table array, column index
=2, and range lookup ="false" I'd like to return the value "5" instead of
"2". Can this be done somehow through an formula?
COL A COL B
Item # Sales
1234 2
5
3
4
2345 6
7
9
1