CODEWITHSUNDEEP
excelexcel-2007excel-formulaexcel-2010
ENGR024
ENGR024

Reputation: 327

Excel using a range of cells to return value corresponding to an adjacent cell

I am using Excelsius 2008 (Excel 2007 plus a dashboard builder) to create dashboards and publish them as webpages.

I have a range of cells A1:A20 that number from 1 to 20. Then Next to it I have B1:B20 that consists of texts (e.g. B1 may have 'High Level", and B2 may have "Low Level", etc.).

I also have indicators on my dashboard. The indicator button image has a label which can be shown when you hover over it (almost like a tool tip message box). Right now the label on the indicator can display a value in the message box with any number from A1:A20 because I have a single cell referencing it (C9). That cell has a vlookup as such:

 =VLOOKUP(C9,$A$1:$B$20,1,TRUE)

But I am trying to make it so if a 6 appears in the cell (C9) and when I hover over the icon I should get the text value from B6 not A6. I am merely using the Column A to match the number in C9 and if they match, then the adjacent cell's (in Column B) text appears.

Can this be done with look up functions or any other command that excel has?

Thanks for the help

Upvotes: 0

Views: 11558

Answers (1)

p0werenner
p0werenner

Reputation: 254

Changing your equation to =VLOOKUP(C9,$A$1:$B$20,2,TRUE) should pull in the value of column B

Upvotes: 1

Related Questions