V-Lookup over multiple sheets

[jamief89]

I have an excel file that has multiple sheets (6 currently but more will be added)
I also have a master sheet that I want to lookup invoice numbers from the other 6 files.
I have created a formula called VLOOKALLSheets but that is pulling data from the master also.

The logic I need is:
Look in Sheet 1, if it's not in sheet 1 then look in sheet 2 ect.......BUT I dont want it to look in the Master sheet.

Can anybody please help?

 

[Comfy]

Can you post your UDF.

 

[VoG]

Can you post your code? Use code tags

[code]
your code here
[/code]