Bob Todd
New Member
- Joined
- Mar 27, 2017
- Messages
- 12
- Office Version
- 2016
- Platform
- Windows
- Mobile
I have a formula below that works great when I search column B through N, but when I change it to column A to N, I get a N/A error.
=VLOOKUP(B3,INDIRECT("'"&INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$B1:$N700"),B3)>0),0))&"'!$B1:$N700"),9,FALSE)
The format of the information in all columns is general.
Thanks for any help.
Bob
=VLOOKUP(B3,INDIRECT("'"&INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$B1:$N700"),B3)>0),0))&"'!$B1:$N700"),9,FALSE)
The format of the information in all columns is general.
Thanks for any help.
Bob