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

[GregoryT]

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F[/TD]

​

[/TR]
[TR]
[TD]Dropbox1
[/TD]
[TD]Dropbox2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Select
[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]peaches
[/TD]
[TD]fresh
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]pears
[/TD]
[TD]Frozen
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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

[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Fruit
[/TD]
[TD="align: center"]Condition
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Select
[/TD]
[TD="align: center"]0
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]peaches
[/TD]
[TD="align: center"]fresh
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]pears
[/TD]
[TD="align: center"]frozen
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.