sample 1.0.xlsx


Hi all,

Thank you for all the good tips on your website but I have been struggling for a while now on this issue.
I am looking to execute a vlook up functions across multiple sheets (+20). Please find attached my file for more clarity.

Basically, in the first sheet I have a serial number (named "APN") and I would like to look for this number in the other sheets (located in the column BU) and return the number/text located in this same sheet but in the column Z.

Something like that:
=VLOOKUP("APN number located in my first sheet", BU:BU, 26,false)

but I would like to do it in multiple sheets.

Thank you for your help,

Julien