Two Drop Down List and INDEX, MATCH FUNCTION

[Devi Suryani]

Hi all,

Hope everything is good with you. Thanks Ramananhrm for your answer. I have another question.

If I want to display thickness of pipe using 2 drop down list (NPS and Sch number), what i should fill in on the thickness shell function?

Thanks for your help.

regards,
Devi S

[FDibbins]

If you want to base it on NPS, use this...
=INDEX($F$3:$X$40,MATCH($C$2,$F$3:$F$40,0),MATCH(C3,$F$3:$X$3,0))

If you want to base it on Sch OD, use this...
=INDEX($F$3:$X$40,MATCH($C$4,$G$3:$G$40,0),MATCH(C3,$F$3:$X$3,0))

[:) Sixthsense :)]

In C4 Cell

=VLOOKUP(C2,F5:X40,MATCH(C3,F3:X3,0),0)

[FDibbins]

Six, OP wants C4, already has C4

[:) Sixthsense :)]

@ FDibbins,

Thanks for the correction

I was not done the data study... Anyhow you provided the solution to the OP by covering both the methods

[Devi Suryani]

Thanks a lot FDibbins, Do you have any reference book that I can buy in Indonesia to learn about excel function, macros etc?

It will be very helpful for me to learn and apply it on my work.

Regards,
Devi S

[FDibbins]

Happy to help.

Sorry, I dont know of any, but a google search using "learn excel in indonesian" turned up a few links that you might want to check out?

http://tutorial-wordexcel.blogspot.com/
http://www.askedu.net/student.asp?Co...a#.UjlJrMZvOXs
these are just 2 that I found

Apart from that, this forum is a VERY good place to learn - ask questions and look at some the suggestions from other members