Hi
I would like to get a look up formula to look at multiple cells, for
example, I have London in A1 and transport in B1. Then London in A2 and
Design in B2 This goes down to A800 and B800 with different locations and
roles.

I then have a list of towns and roles showing their site number, D1 london,
E1 transport, F1 is the site number 1.

I want my formula to see if A1 matchs D1, if E1 matchs B2 show F1.

I then want to drag this down to match all the different types, so it will
show the corresponding site number each time.

I hope that makes sense!

Thanks