Excel 2010: How to have a column display data selected from a table of data?

dank69

Lifer
Oct 6, 2009
37,157
32,586
136
I have a table of data for insurance premiums based on salary range:
pfwgOCD.png


I want to have the premium column in this view display the data from the appropriate table column based on the value entered in the salary box:
cuzji7e.png


Can this be done with built-in excel functionality?
 

PowerEngineer

Diamond Member
Oct 22, 2001
3,601
779
136
Yes, this can be pretty easily done.

The HLOOKUP and VLOOKUP functions are specifically for doing this. You may want to read up on these functions as it may change the way you set up your insurance premium table.

You might also want to look at the MATCH and INDEX functions. I usually use these two functions in combination to do my look ups in Excel.

Good luck.
 

dank69

Lifer
Oct 6, 2009
37,157
32,586
136
Yes, this can be pretty easily done.

The HLOOKUP and VLOOKUP functions are specifically for doing this. You may want to read up on these functions as it may change the way you set up your insurance premium table.

You might also want to look at the MATCH and INDEX functions. I usually use these two functions in combination to do my look ups in Excel.

Good luck.
Yes, thanks. I was able to do it with hlookup. :thumbsup:

I had to change the headers to a single value. For example, the first column header is 0-24999. Then I made the headers into a named group. Then I changed the salary input box to a list where the user can select from the list of headers. Then it's a simple hlookup to get the values. I was hoping there was a way to lookup between ranges but I couldn't figure that out. This new way works great.
 
Last edited:

PowerEngineer

Diamond Member
Oct 22, 2001
3,601
779
136
I think it should work if you just put the low end of the salary range in the first row (and leave off the optional "Range_lookup" argument or set it to TRUE)