need formula for voltage drop calculator vlookup or IF?

[raven_lanozo]

TEST VD.xlsx


please check excel sheet for my inquiry. i have a drop down list in B3 for voltage and B4 for the size of the cable. then field values are in the left side from cell f4:h9. i want to know the formula that will automaticaly select the "K" value based on the table on the left everytime i change the voltage and the type of cable.

[:) Sixthsense :)]

In B8 cell Array Formula - Requires Ctrl+Shift+Enter

=IFERROR(INDEX($G$4:$G$9,MATCH(1,($F$4:$F$9=B4)*($H$4:$H$9=B3),0)),"")

[Kevin UK]

Hi raven_lanozo

This is a duplicate post: http://www.excelforum.com/excel-gene...-in-excel.html

Please see the attached forum rules: ForumRules Rule 5

[raven_lanozo]

Thank you so much Sixthsense