Hello everyone
I have Excel 2003 and a grid of data. Columns A, C and E contain unique
data (one instance of each data value in each column and within the whole
grid) and the data in each of the columns is sorted alpha-numerically (A & B
relate to each other as do C & D and E & F). I need to be able to lookup a
particular value in the whole grid and return the contents of the cell
immediately to the right of the cell that matches the data. The match will
be exact. I had thought about using VLOOKUP but that can't be used to refer
to the whole grid of data (so far as I'm aware) - it would have to refer to
data contained in columns A & B or C & D or E & F. The data that is being
sought may be in any of these columns and this is out of my control.
I'm sure that this is simple - but it's beyond me! How can I perform this
lookup?
Thanks in anticipation.
Bookmarks