Vlookup multiple sheets

[Balmer07]

Hi,

I am currently working on a worksheet, and on the sheet there are 4 tabs which have the same layout but each is a different cost centre.

I need to do a check to see if one number on a master tabappears on any of the 4 cost centre tabs.

Basically I need a vlookup across the 4 tabs but in one cellon the master.

Hopefully this makes sense.

 

[DanteAmor]

Im glad to help you, thanks for the feedback.