About Us

SMOKN_ENG_MOM[_2_]

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

"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!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I set up a multiple selection drop down list?	Colder	New Users to Excel	4	August 25th 06 06:12 PM
Selection of Drop down list that allows you to go to a particular cell	Daphne	Excel Worksheet Functions	2	June 14th 06 09:54 AM
Print each drop-down list selection	Corey	Excel Discussion (Misc queries)	0	May 18th 06 08:39 PM
multiple select from the drop down list in excel. list in one sheet and drop down in	sriramus	Excel Discussion (Misc queries)	5	October 27th 05 06:55 PM
Moved data to new sheet based on list selection	scronk	Excel Worksheet Functions	1	October 18th 05 08:08 AM

Menu

About Us