Assuming the source data is in cols A to F, from row1 down in Sheet1
(with unique data as stated)

In Sheet2
---------
With the look-up value in A1,

Put in B1:

=IF(ISNA(MATCH(A1,Sheet1!A:A,0)),IF(ISNA(MATCH(A1, Sheet1!C:C,0)),IF(ISNA(MAT
CH(A1,Sheet1!E:E,0)),"",INDEX(Sheet1!F:F,MATCH(A1, Sheet1!E:E,0))),INDEX(Shee
t1!D:D,MATCH(A1,Sheet1!C:C,0))),INDEX(Sheet1!B:B,M ATCH(A1,Sheet1!A:A,0)))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Tosca" wrote in message
...
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.