Hello Everybody
Hello Everybody
Last edited by Jschell0309; 11-17-2015 at 11:12 AM. Reason: Incorrect Title
Hello Jschell0309,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
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 there error "#N/A"
Last edited by Jschell0309; 11-17-2015 at 11:13 AM. Reason: Incorrect Title
Try:
=iferror(VLOOKUP([@[K2 TYPE]],Type_Break,2,FALSE),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks