MAtch drop down list selection to data sheet

[SMOKN_ENG_MOM]

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!

 

[Gav123]

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