MAtch drop down list selection to data sheet

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!

Hi,

Maybe you could try VLOOKUP, alomng the lines of..

In the cell where you want your result to be type..

=VLOOKUP(C3,'Contact List'!$C$10:$D$230,2,0)

Hope this helps.

Gav

"SMOKN_ENG_MOM" wrote:

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!