Way to return a column header value?

[Abgirl]

Hi All,

I've had a look around & cant find an answer - so apologies if this has already been answered somewhere!

I have a workbook (example attached) with multiple users & their locations recorded on one tab, then on a separate tab the campus details of their locations (e.g. several different towns make up one 'campus').

I want to find a way of returning the campus name (which is in the header row of the campus tab) based on the location (listed under each campus).

Is there an easy way of doing this?

Thanks!!

[NBVC]

Try:

=INDEX('Campus Data'!$A$1:$D$1,SUMPRODUCT(('Campus Data'!$A$2:$D$5=$B2)*(COLUMN('Campus Data'!$A$2:$D$5)-COLUMN('Campus Data'!$A$2)+1)))

copied down

[Abgirl]

Fantastic!

Thank you - thats just saved me an hour of copy paste