Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brad
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keep the formatting of the cell found using Hlookup Denny Excel Discussion (Misc queries) 4 May 13th 05 09:54 PM
Vlookup and Hlookup Phlogiston2312 Excel Worksheet Functions 1 April 21st 05 04:59 PM
Vlookup and Hlookup Phlogiston2312 Excel Worksheet Functions 2 April 20th 05 05:09 PM
How do I find a value in an array (VLOOKUP? HLOOKUP?) M Skabialka New Users to Excel 2 March 11th 05 02:52 AM
SUMIF - HLOOKUP Combination Mark Excel Worksheet Functions 1 February 4th 05 08:03 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"