Hi,

Suppose your ColA cell is A1 and your two input cells (with 'Line2' and
'!202' in for example) are in A6 and A7.

Then B6 should be

=MATCH(A6,A2:A3,FALSE)

and B7 should be

=MATCH(A7,OFFSET(B1,B6,0,1,4),FALSE)

and the result cell should be

=OFFSET(B1,B6,B7,1,1)

Obviously change the size of the arrays or the length of the range in the
OFFSET function (the 4) as needed.

HTH,

David

"carl" wrote:

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.