Going Blind - what do I need vlookup - index match?

[GregoryT]

A	B	C	D	E	F
Dropbox1	Dropbox2
Select	0
peaches	fresh
pears	Frozen

<tbody>

​

</tbody>

This is driving me nuts got my whole workbook figured out and I m stuck on this 1 thing. Its simple and I am just not seeing it any help please?

I have 2 drop boxes as above. When I select pears from DB#1, I want frozen to appear in box 2 automatically. Or if I select peaches I want fresh to appear. that simple...........not for me lol

I have tried vlookup index match WHAT IS IT!!!!!!!!!

On another sheet called Specs in column A is fruit column B is condition

A	B
Fruit	Condition
Select	0
peaches	fresh
pears	frozen

<tbody>
</tbody>

TIA GregT

 

[GregoryT]

Sorry that should be Dropbox 1 only dropbox2 is actually an empty cell..........

 

[mohadin]

Hi
If I understand
=VLOOKUP($A$2:$A$4,Sheet2!$A$2:$B$4,2,0)

Or
=INDEX(Sheet2!$B$2:$B$4,MATCH(Sheet1!$A$2:$A$4,Sheet2!$A$2:$A$4,0))

 

[GregoryT]

Thks for your assist but I can not get those to work. I dont know what the problem is.....

 

[Fluff]

With the spec sheet like

Book1
	A	B
1	Fruit	Condition
2	Select	0
3	peaches	fresh
4	pears	frozen
Specs

On the sheet with the dropdown

Book1
	A	B
1	Dropbox1	Result
2	Select	0
3	Pears	frozen
4	Peaches	fresh
Sheet1

Cell Formulas
Range	Formula
B2	=INDEX(Specs!$B$2:$B$4,MATCH(A2,Specs!$A$2:$A$4,0))

 

[GregoryT]

Thanks for the reply, there must be something Im doing wrong because nothing has worked. Is there anyway to load the workbook on posts for members to see?

 

[Fluff]

You cannot upload a workbook to the site, but you can put it on a share site such as OneDrive, Dropbox. Mark it for sharing & then post the link to the thread.