Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
97
Views
Topic starter
Hi
I reviewed your multiple vlookup sheets and keep getting NA.
Basically I have 40 worksheets where on all tabs cell F5 has the profit center and cell G5 has the dollar amount I need.
=+VLOOKUP(D2,INDIRECT("'"&INDEX(Sheet_List,MATCH(2,--(COUNTIF(INDIRECT("'"&Sheet_List&"'!$F$5:$g$5"),D2)>0),0))&"'!$f$5:$g$5"),2,FALSE)
When I type the formula above and enter is as an array I still get a N/A.
The Sheet list is a name of all 40 worksheets and D2 is the profit center I would like to find the dollar amount for.
Posted : 05/11/2020 4:25 pm
Hello,
Try with changing MATCH(2 to MATCH(1.
=VLOOKUP(D2,INDIRECT("'"&INDEX(Sheet_List,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet_List&"'!$F$5:$g$5"),D2)>0),0))&"'!$f$5:$g$5"),2,FALSE)
Posted : 05/11/2020 7:39 pm
