Hi,

I am using this =IFERROR(VLOOKUP(A2,data!$A$2:$B$31,2,0),"") to pull in values from a table via a drop down in the Products column(A) that fills in the value in Cost column (B).

Its been working fine but suddenly stopped and I have no idea why or how to fix it.

Any help gratefully received.

table.png