INDEX OR MATCH

[carl]

I have a table like this:

ID Code Notes
BOX549 a2 Drop
BOX355 aA Drop
BOX355 AA Add

I am trying to find a formula for "Notes" Column of table below (note the
Code has upper and lower cases)

Code ID Notes
a2 BOX549 Drop
A3 BOX355
AA BOX355 Add
aA BOX355 Drop
Aa BOX355

 

[barry houdini]

Hello carl,

If your first table is in A1:C4 and you have a code to lookup in E2
and an ID in F2 try this formula in G2 copied down

=LOOKUP("zzzzz",CHOOSE({1,2},"",LOOKUP(2,1/(EXACT(E2,B$2:B$4)*EXACT
(F2,A$2:A$4)),C$2:C$4)))

 

[T. Valko]

See your other post(s)

http://tinyurl.com/9rgcxx