Hi All

=IF('Date Details'!C3=Itininary!L4,('Date Details'!C5),IF('Date
Details'!D3=Itininary!L4,('Date Details'!D5),IF('Date
Details'!E3=Itininary!L4,('Date Details'!E5),(0))))

In the above I am seaching along row 3 starting from c to Find a date match
in Itininary L4 WHEN IT IS ACHIEVED RETURNS TEXT IN 'DATE DETAILS'! row 5.

Trouble is row 3 goes thru 253 columms. Can this repetive formula me made
shorter ,and in the process I learn More, or do i have to keep going 253
times?

Thanks to all you helpers out there. I look forward to being able to answer
a few questions myself

Stew