Hi,

I have an issue I can't resolve and wondered if it is possible...

I have a table on sheet 2

sheet 2.jpg

and I have another table on sheet 1

sheet 1.jpg

When I put a dept in sheet 2 in (column B) I want it to automatically look for that department in the table in sheet 1 and then return the value of which team (A or B) it responds to in to column C...

Any ideas how I might achieve this please as I'm a bit of a novice and unsure?

Many thanks