Drop down list

[mihaibantas]

Hello everyone, I have a problem related to the drop-down list, more precisely when I change a value from list B1 I want to display a predefined value only for B1 in cell D1. I am also attaching some pictures to clarify my request. Thank you in advance.
step 1

step 2

step 3

 

[keef2]

What version of excel are you using?

 

[keef2]

Here is one way that could work with a helper column by your data validation list.

Book1
	H	I	J	K	L	M	N	O
1	Fixed	Select	Formula				Data Validation List
2	5	3c	3				1a	1
3	6	2b	2				2b	2
4	2	3c	3				3c	3
5	35	6f	6				4d	4
6	20	4d	4				5e	5
7	30						6f	6
Sheet1

Cell Formulas
Range	Formula
J2:J7	J2	=IFERROR(VLOOKUP(I2,$N$2:$O$7,2,FALSE),"")

Cells with Data Validation
Cell	Allow	Criteria
I2:I7	List	=$N$2:$N$7

 

[mihaibantas]

hello,i use a version of Excel 2016 x64, the formula applies very well, but I was wondering if we apply the data from column O directly to the formula without writing column O?
Thanks for your time.

 

[Fluff]

i use a version of Excel 2016 x64

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[keef2]

Hey there not sure i understand. I just plugged the data into a random white space. You can change ranges and locations for anything. Also you would have to update with appropriate data.

 

[mihaibantas]

I tested the following formula =IF(OR(ISNUMBER(SEARCH("string1", cell)), ISNUMBER(SEARCH("string2", cell))), value_to_return, "") it only worked for two cells...and I was wondering if there is something more extensive that can be applied to my request. thanks

 

[Kerryx]

Book1
	B	C	D	E	F	G
1	Select		Return		List
2	1a		10		1a	10
3					2b	5
4					3c	15
5					4e	22
6					5f	33
7					6g	44
8					7h	55
Sheet2

Cell Formulas
Range	Formula
D2	D2	=FILTER(G2:G8,F2:F8=B2)

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$F$2:$F$8

 

[mihaibantas]

Hello Kerryx, i received the following message to your formula "That function isn't valid". My version of Excel is 2016 x64 maybe that's the reason?
Thanks for your time.

 

[Fluff]

"That function isn't valid". My version of Excel is 2016 x64 maybe that's the reason?

Please see post#5 & act on it, thanks.