Dave, thanks so much for your response - stuck in the middle of nowhere in
the UK at the moment with no heating so would be good to sort this!!

I have sent the sheets to your yahoo.com email address - hope you don't mind.

"Dave O" wrote:

Yes: check out VLOOKUP in Help. It will look up an item in a range and
return another cell from within that range. Note, however, that the
spelling of site names or whatever your lookup value is must match
exactly. Please post examples of your data if you get stuck.