I require a formula to which looks for a data in multiple sheets. I need to link the MakeID in the Make sheet to the Model sheet MakeID, I have manually inserted a sample of what is required resulting the in the MakeID 265 populating the cells, there are too many for this to be done manually so I am looking for a formula I can use to do this.
Regards Paul