Hello, I have 2 tabs in this workbook: TEK01_TEK02 and TEKNION SCRAP DATA.

The area in blue in TEK01_TEK02 is where I need the functions written out.

My lookup values will be in TEK01_TEK02, columns A (Die A-2xxxx) and M-AE (i.e. 100%IN1, 100%INS, 100%QC, etc.).

The data needs to be pulled from TEKNION SCRAP DATA. Basically, from TEKNION SCRAP DATA, if columns A and B match columns A and M from TEK01_TEK02 tab, I want it to return the value of column I from TEKNION SCRAP DATA.

That should be clear I think? I’ve tried using Index match, but it’s not generating the right information for me. I tried using VLOOKUP too, and I’m still lost.

Thanks,

Audrey