Lookup or Match ?
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.
|