Problem Transferring Formula from Test Sheet to Master Sheet

[Jim Clayton]

I have a formula that I got some help on earlier today. It works great it the test workbook that I made, but when I went to apply it to this workbook that I’m actually working on, I’m running into issues. I’ve been trying to modify it but I can’t seem to get it to work for me, so here I am.

The workbook is laid out as follows: Column F is identical to Column O on Sheet 1. I’m placing the formula in E2 and it’s supposed to reference Column A of Sheet 2 and populate it with the data from Column B from Sheet 2. There will be blanks.

Recapping; Look at column F or O on Sheet 1, cross reference with Column A on Sheet 2, fill column E on Sheet 1 with data from Column B on Sheet 2. Formula is below. Workbook is attached. Would greatly appreciate any help with this. Tks.

=IFERROR(INDEX(Sheet2!$B$1:$B$2911,MATCH(Sheet1!F2,Sheet2!$A$1:$A$2911,0),1),"")

[AliGW]

You don’t need a new thread for this. It’s not a new issue and it would make far more sense to continue in the original thread, so this one is now being closed.