Emmaknighton
New member
- Joined
- Jul 10, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
How can I add tabs to this formula? I also want to search the worksheets RVST, ICDC, HSON, STIN, USED, FIXD within the same workbook. Formula is working on REVF & BORA worksheets. =IF(ISNA(VLOOKUP(Y3,'[Job Number Record.xlsx]BORA'!$1:$9000,4,0)),VLOOKUP(Y3,'[Job Number Record.xlsx]REVF'!$A$1:$H$9000,4,FALSE),VLOOKUP(Y3,'[Job Number Record.xlsx]BORA'!$A$1:$H$9000,4,FALSE))