hello,
let me first say that I'm aware there are numerous threads explaining multiple Vlookups but this is somthing slightly different.
I have a report I produce every morning and unfortunately a vital bit of data does not pull through. so I use a different sheet to vlookup them. Sometimes they wouldn't all be on one sheet so I'm having to vlookup each sheet one at a time.
Until I found this
=IF(ISERROR(VLOOKUP($K1,'[Rcvd 17 Apr 11 PS.xlsx]Detail'!$K$2:$O$27000,5,FALSE)),#N/A,VLOOKUP($K1,'[Rcvd 18 Apr 11 PS.xlsx]Detail'!$K$2:$O$27000,5,FALSE))
this is useful as it lets me search two at a time but sometimes I'm having to search through 10-20 before they match.
is there anyway in excel so that it would let me type the filename of a folder and then have it search through every excel file within that folder until a match is found.
(all excel files are the exact same format and named in the same format also).
Anyway, thankyou to anyone who spends some time on this. it will be greatly appreciated.
let me first say that I'm aware there are numerous threads explaining multiple Vlookups but this is somthing slightly different.
I have a report I produce every morning and unfortunately a vital bit of data does not pull through. so I use a different sheet to vlookup them. Sometimes they wouldn't all be on one sheet so I'm having to vlookup each sheet one at a time.
Until I found this
=IF(ISERROR(VLOOKUP($K1,'[Rcvd 17 Apr 11 PS.xlsx]Detail'!$K$2:$O$27000,5,FALSE)),#N/A,VLOOKUP($K1,'[Rcvd 18 Apr 11 PS.xlsx]Detail'!$K$2:$O$27000,5,FALSE))
this is useful as it lets me search two at a time but sometimes I'm having to search through 10-20 before they match.
is there anyway in excel so that it would let me type the filename of a folder and then have it search through every excel file within that folder until a match is found.
(all excel files are the exact same format and named in the same format also).
Anyway, thankyou to anyone who spends some time on this. it will be greatly appreciated.
Last edited:
