I am using the VLOOKUP function to extract values from another worksheet. Can someone please suggest how I alter the function to return a blank cell when the Lookup_Value is not found in the worksheet from which I’m calling data?
Thanks!
I am using the VLOOKUP function to extract values from another worksheet. Can someone please suggest how I alter the function to return a blank cell when the Lookup_Value is not found in the worksheet from which I’m calling data?
Thanks!
Last edited by andrewc; 02-08-2011 at 12:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks