This site might help you
Two-way lookup
http://j-walk.com/ss/excel/usertips/tip020.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Jonesy" wrote in message
...
My problem is I work in a muanfacturing plant where we reference shifts in
2
different formats Nights,Earlys & Lates or A,B & C Shift.

I have set up a speadsheet in excel where I download data weekly from
another program for Weekly Scrap, OEE & Downtime Data.

My problem is in the columns reading from the left I have Date & Shift and
I
want to use both to lookup against. For example 02.09.08 & Early in the
data
set on a seperate sheet I would a Date File in order showing on a
particular
Date & Shift it would be C - 02.09.08 Early C.

Pleae help as we work a rotating 3 Shift pattern so If I could link the
shift A,B or C to the database would be a massive help

Thanks
Regards
Jonesy