Another play ..

Assume the source below is in Sheet1, data from row2 down

ColA ColB ColC ColD ColD
Line1 !55 200 !202 ABC
Line2 !202 EFG !55 1000

In Sheet2
--------
Assume this table below is in A1:C3

!55 !202
Line1 ?? ??
Line2 ?? ??

Put in B2:

=OFFSET(Sheet2!$B$1,MATCH($A2,Sheet2!$A:$A,0)-1,MATCH(B$1,Sheet2!$B2:$E2,0))

then copy B2 across to C2, fill down to C3 to populate the grid

This will return the desired results:

!55 !202
Line1 200 ABC
Line2 1000 EFG

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"carl" wrote in message
...
My data comes in like this:

ColA ColB ColC ColD ColD
Line1 !55 200 !202 ABC
Line2 !202 EFG !55 1000

I am trying to fill in a table like this:

!55 !202
Line1 200 ABC
Line2 1000 EFG

So, in this new table, I would like the formula to look at the ColA (eg
"Line1") and ColB (eg "!55") and return the appropriate value from the
original data table.

Is this possible ?

Thank you in advance.