nmolliconi
asked on
Vlookup(Match) formula in Excel
Good Afternoon,
Getting a NA# on a vlookup(match) formula within excel (see attached document). The formula: =IF(VLOOKUP(B1,'DATA INPUT'!$A$2:$I$346,MATCH(S UMMARY!A2, 'DATA INPUT'!$A$2:$I$346,0),FALS E)=0,"",(V LOOKUP(B1, 'DATA INPUT'!$A$2:$I$346,MATCH(S UMMARY!A2, 'DATA INPUT'!$A$2:$I$346,0),FALS E)))
Any guidance would be much appreciated.
Thank you
Nick
test-file.xls
Getting a NA# on a vlookup(match) formula within excel (see attached document). The formula: =IF(VLOOKUP(B1,'DATA INPUT'!$A$2:$I$346,MATCH(S
Any guidance would be much appreciated.
Thank you
Nick
test-file.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nick