ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HLOOKUP improvement? (https://www.excelbanter.com/excel-worksheet-functions/30480-hlookup-improvement.html)

Brad

HLOOKUP improvement?
 
I need split age information between two columns depending on the age
(details below at the bottom of the message).

For example if the person is 55 in column one I would show age information
for ages 60, 62, and 65 and in column two I would show age information for
ages 70, 72 and 75.

But for age 66 I would only show in column one age 70 and in column 2 age 75.

The below equation works - however is there a simplier way to do this?

=IF(HLOOKUP(+'Policy information'!$C$5,$B$2:$H$9,A12)="","
",HLOOKUP(+'Policy information'!$C$5,$B$2:$H$9,A12)) (A12 is in an array
with values ranging from 2 to 8)

0 55 60 62 65 70 72
55 60 62 65 70 72 75
60 62 65 70 72
62 65 70
65
70 70 72 72 75 75
72 72 75 75
75 75



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com