I am trying to match a selected item from a drop down list (sheet 1) to a
column on another sheet(2) and return information from another column on
sheet 2 to an independant cell on sheet 1.
I have tried
=LOOKUP(C3,'Contact List'!$C$10:$C$230,'Contact List'!$D$10:$D$230)
=IF(C3='Contact List'!C:C,'Contact List'!B:B,"")
{=INDEX('Contact List'!B:B,MATCH('Enter New Event'!C3='Contact List'!C:C,0))}
None of these are Working! PLEASE HELP. THis is due tomorrow!