error #N/A

[MATU70]

Hi

I kindly got a formula from a user on this site which works but when no data is input in A1, B1 returns an error #N/A which i really dont want as i have totals being calculated from four different tables, of which all sub totals on each table is being effected by #N/A.

this is the formula: =LOOKUP(A1,{6,16,36,66},{25,15,5,0})

i have attached a sheet for anyone who wants to correct the formula for me

Thank You

[Richard Buttrey]

Hi,

Just wrap it in an IFERROR() function. i.e.

=IFERROR(LOOKUP(A1,{6,16,36,66},{25,15,5,0}),"")

[martindwilson]

or
=LOOKUP(A1,{0,6,16,36,66},{0,25,15,5,0})