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...
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...
I think you mean:
=IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$M$13,'Customers'!$O$4:$O$13)))
Dan
Don't forget to ☆ me if I helped you!
Can you post a copy of your spreadsheet for me to look at?
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.
Entia non sunt multiplicanda sine necessitate
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks