I'm looking for help with my formula. =(VLOOKUP([@[K2 TYPE]],Type_Break,2,FALSE))
It is setup to find data from a column within a table, which is pulling data from another table on a different worksheet.
I want it to show"0" if there is no data found, but I get this error "#N/A"
Try
=IFERROR(VLOOKUP([@[K2 TYPE]],Type_Break,2,FALSE),0)
AWESOME!!!
Thansk Jonmo1
You're welcome.
I'm having trouble when I try to add certain criteria. When there is data in all 9 VLOOKUP's it works fine, but if there is no data in any one of them, it remains "0".
=IFERROR(SUM(VLOOKUP(Delivery[@[K1 TYPE]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[K2 TYPE]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[K3 TYPE]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[BATH 1]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[BATH 2 TYPE]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[BATH 3 TYPE]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[MISC 1]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[MISC 2]],Unit_Type,3,FALSE),VLOOKUP(Delivery[@[MISC 3]],Unit_Type,3,FALSE)),0)
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks