VLOOKUP for Multiple Sheets

[cfherd]

Please Login or Register  to view this content.

I am using the above formula as a lookup over several sheets however I think there may be a more robust method of doing this as I have to keep it compatible with Excel 03 and I may over time have to add more sheets to lookup to and I've already reach the maximum nested IFs.

I am a beginner with VBA but think there must be a way of converting this into code using a loop but I am struggling to convert the logic.

Any help would be appreciated.

Thanks
Chris

[Pepe Le Mokko]

Why not merge the sheets and do the LOOKUPS in the summary sheet?

[Fotis1991]

Hi

Take alook to Jerry's site.

https://sites.google.com/a/madrocket...ssistant/files

[cfherd]

Jerry's site cracked it! Thanks.