VLOOKUP returns #N/A although lookup value is there in the table array. Formats are also same for both the values.
VLOOKUP returns #N/A although lookup value is there in the table array. Formats are also same for both the values.
The problem is in the formula. You have indicated the formula to find the item in the list, and then return the content of column "0". The columns must begin counting with "1". Since there is no column "0" the result is N/A.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks