I am using the following formula in Excel 2010 and getting the data I want: =IFERROR(VLOOKUP(C2,WC!F$4:I$281,4,FALSE),0). I sent the excel form out to others using Excel 2003 and there getting #NAME? in the cells instead of numbers. Some things I double checked are making sure I saved it as a "xls" file. I also made sure the cell formats of all cells matched. Other then that, I am not sure how to make it work for them. Any help would be awesome.
Hi,
IFERROR() isn't compatible with 2003.
Regards
The IFERROR function is not available in Excel versions 2003 and earlier.
This formula will work in any version of Excel:
=LOOKUP(1E100,CHOOSE({1,2},0,VLOOKUP(C2,WC!F$4:I$281,4,0)))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Another possibility...
=SUMIF(WC!F$4:F$281,C2,WC!I$4:I$281)
Formula:
Please Login or Register to view this content.
Nice alternative error trap!Originally Posted by Tony Valko
Thanks!
Saves from having to do the lookup twice.
Thanks guys! Awesome help!
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks