ExcelBanter - INDEX OR MATCH

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - INDEX OR MATCH (https://www.excelbanter.com/excel-worksheet-functions/214831-index-match.html)

Carl

INDEX OR MATCH

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[_4_]

INDEX OR MATCH

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

INDEX OR MATCH

See your other post(s)

http://tinyurl.com/9rgcxx

--
Biff
Microsoft Excel MVP

"carl" wrote in message
...
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

All times are GMT +1. The time now is 04:44 PM.