View Full Version : CHOOSE with HLOOKUP
KongUK
09-26-2017, 06:18 AM
Hi
I have done CHOOSE with VLOOKUP to look back in a table, I need to do this with HLOOKUP
So row 4 is lookup data to return row 1
Range is L1:AM4
I have tried playing with range but can only get it working row 1 to 4
=HLOOKUP(D80,CHOOSE({1,2},'Stacking Analysis'!L1:AM4,'Stacking Analysis'!L1:AM4),1,FALSE)
Thanks
mdmackillop
09-26-2017, 10:16 AM
Can you post sample data. Go Advanced / Manage Attachments
KongUK
09-27-2017, 08:27 AM
I decided to rearrange the data and transposed into a basic VLOOKUP so requirement is gone
Thanks
Frederic
09-28-2017, 03:25 AM
I have a similar issue to KongUK.
I need a formula that if the cell falls under such such month and date , then the look up for the attributed value.
See below the data set:
1
2
3
4
5
6
7
8
9
10
11
12
2018
10.33
10.33
10.33
10.33
10.33
10.33
10.33
10.33
10.33
10.33
10.33
10.33
2019
20.67
20.67
20.67
20.67
20.67
20.67
20.67
20.67
20.67
20.67
20.67
20.67
2020
31.00
31.00
31.00
31.00
31.00
31.00
31.00
31.00
31.00
31.00
31.00
31.00
2021
41.33
41.33
41.33
41.33
41.33
41.33
41.33
41.33
41.33
41.33
41.33
41.33
2022
51.67
51.67
51.67
51.67
51.67
51.67
51.67
51.67
51.67
51.67
51.67
51.67
2023
62.00
62.00
62.00
62.00
62.00
62.00
62.00
62.00
62.00
62.00
62.00
62.00
2024
72.33
72.33
72.33
72.33
72.33
72.33
72.33
72.33
72.33
72.33
72.33
72.33
2025
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
2026
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
2027
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
2028
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
82.67
See below where the formula falls under;
Financial Year Start
1-Jan-17
Financial Year End
31-Jan-17
Period duration
31
1
Calandar Year
2017
Project Duration
0
Revenues
Operating Revenue
=Fomula will be here
Do you have a solution to lookup based on such info in a 2 dimension data set ?
Thanks in advance for your help
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.