vlookup stopped working

**Pepe Le Mokko** · 01-23-2013, 03:22 PM

I get a message " Invalid attachment" trying to open your file . You probably missed the last step of attachment wizard ( load online or sthg).
Perhaps try to re-post

**rchapman** · 01-23-2013, 05:44 PM

sliding_payment_ plan_forum.xlsx

should have worked this time

**Tony Valko** · 01-23-2013, 06:09 PM

This formula works OK for me:

=IFERROR(VLOOKUP(A2,data!A$3:B$21,2,0),"")

Some of the results of your current nested IF formula are incorrect.

**rchapman** · 01-23-2013, 06:24 PM

Originally Posted by Tony Valko

This formula works OK for me:

=IFERROR(VLOOKUP(A2,data!A$3:B$21,2,0),"")

Some of the results of your current nested IF formula are incorrect.

Thanks for that

Do the selections work in column A where it defaults to 'choose product' and what errors are there?

**Tony Valko** · 01-23-2013, 06:31 PM

There are no entries that say "choose product". They say "choose asset" and the formula returns a blank on those entries because there is no match on the data sheet. There is a "choose product" entry on the data sheet but the corresponding Cost cell is empty.