Need help in getting the value

[amitmodi_mrt]

Hi, I have data something similar as below:

A1 Category1 B1 Category2 C1 Code
A2 Fruits B2 Apple C2 100
A3 Fruits B3 Banana C3 101
A4 Fruits B4 Oranges C4 102
A5 Vegetable B5 Tomato C5 201
A6 Vegetable B6 Potato C6 202


Now in col F2 & G2 I have drop down from where I can Select Category1 and Category2, I need a formula for col H2 which can show me the code (which is col C) for the selected categories. Please help.

Thanks

[TMS]

Just use VLOOKUP and search for Category 2. Category 1 is redundant unless you can have an item that is both Fruit and Vegetable.

[amitmodi_mrt]

Just use VLOOKUP and search for Category 2. Category 1 is redundant unless you can have an item that is both Fruit and Vegetable.

I have fruits listed as Tomato as well with a diff code..

[FDibbins]

Try this...

	A	B	C	D	E	F	G	H
1	Category1	Category2	Code
2	Fruits	Apple	100			Fruits	Apple	100
3	Fruits	Banana	101
4	Fruits	Oranges	102
5	Vegetable	Tomato	201
6	Vegetable	Potato	202

H2=INDEX($C$2:$C$6,MATCH(F2&" "&G2,INDEX($A$2:$A$6&" "&$B$2:$B$6,0),0))

[amitmodi_mrt]

I am unable to upload the sample excel file, so i attaching one picture of the excel sheet.
In Col H2 , I need the code for the category1 and Category2, Please note that category2 can be same in for Category1 with different code. (like Tomato is in fruits as well as in vegetable with diff codes)

Please help.

Attachment 464192

[FDibbins]

Why are you unable to upload a sample file?
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

(did you see my suggestion in post #4?

[amitmodi_mrt]

Thank you FDibbins... it works perfectly the way i was looking for.. Thanks a ton..

[amitmodi_mrt]

Thanks FDibbins, your previous reply worked very well..

[TMS]

Fair enough. Although, technically, I understood that a tomato WAS a fruit, NOT a vegetable

[FDibbins]

happy to help