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..

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

Dan

Originally Posted by Danerida
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

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

Originally Posted by Danerida
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

This version worked for me:
Formula:
`Please Login or Register  to view this content.`

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

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.

Originally Posted by 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.
=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...

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1