Hi

Might be a really daft question but how do I run a Vlookup across multiple workbooks so I have one master report that logs all sales inquiries and then each sales person has an individual tracker so I want to be able to clearly show on the master

A. does the data exist in one of the 8 individual trackers
B. if it does return the status

I'm fine doing this across one but seem to be coming unstuck when I'm trying to do it across 8 different workbooks in one formula??

Thanks