Index Match 2 criteria's and return two results from 2workbooks

[Rodrigues]

Hi There
Need some help, please.
I have a file with 2 workbook (sheet1 and sheet2, on sheet1 have various columns, where on sheet2 only have 4 columns, however both worksheets have hundreds of rows.

What I'm looking after is that:
On sheet1 A2:A4 & F2:F4 (as a index)
On sheet 2 look and match above
On sheet 1 U2 & V2 return matched values from sheet2, if not match found, return "No Match Found"
Have attached a file with some name managers created..
Thanks in advance.
Regards
R

 

[bosco_yip]

Try,

In U2, copied right to V2, and all copied down :

=IFERROR(LOOKUP(1,0/(Product_Code=$A2)/(Units_Case=$F2),IF(U$1="Part ID",Product_Code,Units_Case)),"No Match Found")

Regards
Bosco

 

[Rodrigues]

Bosco,
apologies as forgotten to thank you.
Regards
R