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