On the attached for sheet2 I am not sure what is wrong with my formula in column Q I am getting N/A. Please help!
On the attached for sheet2 I am not sure what is wrong with my formula in column Q I am getting N/A. Please help!
Am I missing Something? When I look at the Formula:
=VLOOKUP(A8,'Budget With Drivers'!A:C,3,0)
This means its looking up the director fees from "Budget with Drivers" sheet.
When I go to that shee I dont see "815161-0000 Director Fees" in Column A at all.
If I do a Search for "815161-0000 Director Fees" its not found in the Sheet at all.
Hi JBailey,
simple cause: the values in sheet2 column A simply do not exist in column A of the buget with drivers table
Regards
Theo
Remember To Do the Following....
1. Upload sample files
2. Thank those who have helped you by clicking the Star below the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Your VLOOKUP()s are looking for matches in col A of the other sheet but matches are not being found.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks