Excel alternative to LOOKUP?

Hi,

See attached spreadsheet

I want users to enter "X" in row 2 and the selected value is displayed in cell B3

I am using an Excel to Web tool which doesn't cater for this, it there alternative method?

Thanks in advance
Test-Lookup.xlsx
rwallacejAsked:
Who is Participating?
 
krishnakrkcConnect With a Mentor Commented:
Hi

Does this work ?

=INDEX(B1:I1,MATCH("x",B2:I2,0))

Kris
0
 
rwallacejAuthor Commented:
works great, thank-you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.