hi juan. do not use the double quotes for numbers:
=IFERROR((VLOOKUP(B3,I13:J14,2,0)*8),"0")
that makes it a text. and text are regarded as greater than numbers in excel. try:
="a">10000
you can also remove the additional brackets & lock the range so that you can copy down:
=IFERROR(VLOOKUP(B3,$I$13:$J$14,2,0)*8,0)
Bookmarks