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