S Shabbo Member May 26, 2019 #1 Dear Sir, Can you please check why V lookup is not working in consolidated sheet is showing NA but Invoice number 263 is available in sheet 1. Attachments why vlookup is not working.xlsx 10.9 KB · Views: 4
Dear Sir, Can you please check why V lookup is not working in consolidated sheet is showing NA but Invoice number 263 is available in sheet 1.
V vletm Excel Ninja May 26, 2019 #2 Shabbo Syntax: = VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) The lookup_value argument can be a value, a reference, or a text string.
Shabbo Syntax: = VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) The lookup_value argument can be a value, a reference, or a text string.
S Shabbo Member May 26, 2019 #5 vletm said: Your 263 is TEXT, not NUMBER which is in Sheet1. Click to expand... Dear Sir, What is Solution now, there are so many data is big.
vletm said: Your 263 is TEXT, not NUMBER which is in Sheet1. Click to expand... Dear Sir, What is Solution now, there are so many data is big.
V vletm Excel Ninja May 26, 2019 #6 Sheet1 has NUMBERS - okay? Other sheet has TEXT - okay? Those not match! Which are less? You should use in both sheets as numbers or text - not mixed!
Sheet1 has NUMBERS - okay? Other sheet has TEXT - okay? Those not match! Which are less? You should use in both sheets as numbers or text - not mixed!
