Please help NA error

[afterthoughts]

Hi could someone help me I get a na error with this code

=IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$O$13,'Customers'!$O$4:$O$13)))

I can't figure out how to use isna or put in the function in the above code..
Please help...

[Danerida]

I think you mean:
=IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$M$13,'Customers'!$O$4:$O$13)))

Dan

[afterthoughts]

I think you mean:
=IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$M$13,'Customers'!$O$4:$O$13)))

Dan

I tried it and I get a #Name? error now

[Danerida]

Can you post a copy of your spreadsheet for me to look at?

[afterthoughts]

Can you post a copy of your spreadsheet for me to look at?

I would rather not as it has alot of personal data in it
Thanks any ways

[Danerida]

This version worked for me:

Please Login or Register  to view this content.

The single quotes are removed (') around the sheet name.
Dan

[shg]

What happens with

=IF(B10="", "", B4 + LOOKUP(F14, 'Customers'!$M$4:$O$13))

If that still results in #N/A, then the smallest value in M4:M13 is larger than F14.

[afterthoughts]

What happens with

=IF(B10="", "", B4 + LOOKUP(F14, 'Customers'!$M$4:$O$13))

If that still results in #N/A, then the smallest value in M4:M13 is larger than F14.

=IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$O$13,'Customers'!$O$4:$O$13)))
The M$13 you changed is a O not a zero
I just deleted the reference and it's working now
Thanks for your help this forum is the best...

[shg]

You're welcome.