MAtch drop down list selection to data sheet

  • Thread starter Thread starter SMOKN_ENG_MOM
  • Start date Start date
S

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!
 
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
 
Back
Top