• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

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
0
rwallacej
Asked:
rwallacej
1 Solution
 
krishnakrkcCommented:
Hi

Does this work ?

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

Kris
0
 
rwallacejAuthor Commented:
works great, thank-you
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now