Excel Help please

Ernie Cooley · 11-12-09, 08:42

Hi

I am trying to get my sheet to auto populate contents in certain cells depending on which item you use in a drop down menu.

I can get the first on the list to show what I want, but whenever I select the 2nd or below, there is an error.

Dropdown is in F2, trying to get the data to work in H&I2 respectively.

The validation table looks at is K2 and the items below, I am trying to get the corresponding values from L2 and below and M2 below

Copy of the sheet attached.

Formula in H2 is =IF(F2=K2,L2)
Formula in L2 is =IF(F2=K2,M2)

TIA

[IMG]file:///C:/DOCUME%7E1/acooney/LOCALS%7E1/Temp/moz-screenshot.png[/IMG]

Mussels · 11-12-09, 11:20

Name the table and then use vlookup.

In cell H2: =VLOOKUP(F2,table,2,FALSE)
In cell I2: =VLOOKUP(F2,table,3,FALSE)

Ernie Cooley · 13-12-09, 16:02

Cheers !!

11-12-09, 11:20	#2
Mussels Should Get Out More Join Date: Jan 2008 Location: Not in London Posts: 5,988 Cash: £1945904 Thanks: 205 Thanked: 105/102	Re: Excel Help please Name the table and then use vlookup. In cell H2: =VLOOKUP(F2,table,2,FALSE) In cell I2: =VLOOKUP(F2,table,3,FALSE)

13-12-09, 16:02	#3
Ernie Cooley Really Bored Join Date: Jan 2008 Location: Oooop North, just far enough outside Keighley Posts: 2,103 Cash: £2500400 Thanks: 151 Thanked: 99/74	Re: Excel Help please Cheers !!
	www.dannyhorneracing.co.uk

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode


These advertisements are reduced in size when you become a registered member and removed when you become a TRC Supporter / Sponsor member.

The following user says thank you to Mussels for this useful post:
Ernie Cooley (13-12-09)

Excel Help please

Hi I am trying to get my sheet to auto populate contents in certain cells depending on which item you use in a drop down ...