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

[dank69]

I have a table of data for insurance premiums based on salary range:

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:

Can this be done with built-in excel functionality?

 

[PowerEngineer]

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]

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.

 

[PowerEngineer]

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)