I have created a helper column in column B, and used this formula which allowed me to populate column F, searching against column E =IFNA(VLOOKUP($E2&COLUMNS($F$1:F1),$B$2:$C$14,2,0),"")

The trouble I am having is using this across different workbooks, when I am trying to populate a spreadsheet with data using the helper column. I have tried adapting the forumla but it isn't quite working.

Can anyone offer any advice or better ways to go about this?

Thanks