How to get index of selected item in drop down list?

nleahcim,

Attached is a sample workbook based on the criteria provided. I did expand it to 10 columns and 100 rows, though. I put the Row drop-down list in cell N2 and the Column drop-down list in cell N3. N4 contains the result using the following formula:

=IF(OR(N2="",N3=""),"",INDIRECT("R"&MATCH(N2,A2:A101,0)+1&"C"&MATCH(N3,B1:K1,0)+1,FALSE))

Hope that helps,
~tigeravatar

nleahcim,

Alternate formula in cell N4 using VLookup:

=IF(OR(N2="",N3=""),"",VLOOKUP(N2,A:K,MATCH(N3,A1:K1,0),FALSE))

~tigeravatar

Originally Posted by tigeravatar

nleahcim,

Attached is a sample workbook based on the criteria provided. I did expand it to 10 columns and 100 rows, though. I put the Row drop-down list in cell N2 and the Column drop-down list in cell N3. N4 contains the result using the following formula:

=IF(OR(N2="",N3=""),"",INDIRECT("R"&MATCH(N2,A2:A101,0)+1&"C"&MATCH(N3,B1:K1,0)+1,FALSE))

Hope that helps,
~tigeravatar

That's awesome. Your method makes perfect sense and it works great! Thanks so much for the prompt and super helpful response!