Hi

I am trying to match values in three different spreadsheets in the same workbook. The formula that I have selected is =IFERROR(VLOOKUP(A2,PO!B:B1,0),"no").

Instead of returning the matching value, it is only returning the word no in every cell incorrectly. How can I modify the formula successfully so that the matching values are shown?

Thank you Excel super-users!