Quick lookup problem

[Roughhouse]

I have two sheets.

In sheet 1 I have a table with Column A being "Materials" and Columns C-E being "Factories", with the factory number being listed in row 1.

In Sheet 2 I have Column A being "Materials" and Column B being "Factories"

What I am trying to accomplish is have the sheet one populate itself with an "x" if the material in column A is found at the facility listed at the top of the column.

 

[Aladin Akyurek]

Sorry for too much info there, but the formula still sin't working. I am getting blanks all the way across. If I remove the IFERROR and the IF statements then all the cells populate with 3000.

I'm sorry it's the nature of your data I missed...

In AA2 enter and copy across:

=IFERROR(IF(INDEX(Pricing!$B$537:$B$555,MATCH(AA$2,Pricing!$C$537:$C$555,0))=$D2,"X",""),"")

 

[Roughhouse]

Excellent both of the most recent ones worked. Alan had to modify your slight by changing AA$2 to AA$1, otherwise I was getting circular reference. But with the correction it works perfect.

=IFERROR(IF(INDEX(Pricing!$B$537:$B$555,MATCH(AA$2,Pricing!$C$537:$C$555,0))=$D2,"X",""),"")

Thanks for all the help.

 

[Aladin Akyurek]

Excellent both of the most recent ones worked. Alan had to modify your slight by changing AA$2 to AA$1, otherwise I was getting circular reference. But with the correction it works perfect.

=IFERROR(IF(INDEX(Pricing!$B$537:$B$555,MATCH(AA$2,Pricing!$C$537:$C$555,0))=$D2,"X",""),"")

Thanks for all the help.

Happy to hear that. Thanks for providing feedback.

 

[T. Valko]

Excellent both of the most recent ones worked. Alan had to modify your slight by changing AA$2 to AA$1, otherwise I was getting circular reference. But with the correction it works perfect.

=IFERROR(IF(INDEX(Pricing!$B$537:$B$555,MATCH(AA$2,Pricing!$C$537:$C$555,0))=$D2,"X",""),"")

Thanks for all the help.

You're welcome. Thanks for the feedback!