CHOOSE with HLOOKUP

[KongUK]

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]

Can you post sample data. Go Advanced / Manage Attachments

[KongUK]

I decided to rearrange the data and transposed into a basic VLOOKUP so requirement is gone

Thanks

[Frederic]

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