Hlookup or Index/Match ?

[audrey]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Dropdown (Month)
[/TD]
[TD]Amount
[/TD]
[TD]Jan/19
[/TD]
[TD]Feb/19
[/TD]
[TD]Mar/19
[/TD]
[TD]Apr/19
[/TD]
[TD]May/19
[/TD]
[TD]Jun/19
[/TD]
[TD]Jul/19
[/TD]
[TD]Aug/19
[/TD]
[TD]Sep/19
[/TD]
[TD]Oct/19
[/TD]
[TD]Nov/19
[/TD]
[TD]Dec/19
[/TD]
[/TR]
[TR]
[TD]Mar/19
[/TD]
[TD]1000
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1000
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hello, what would be easiest formula to pull the "Amount" in B2 to appear in the correct month from C2:M2 ?

Thank you for your help!

Audrey

 

[arthurbr]

Like =INDEX($C2:$N$2,match(A2,$C$1:$N$1,0)) in B2 ?

 

[audrey]

Like =INDEX($C2:$N$2,match(A2,$C$1:$N$1,0)) in B2 ?

Hi arthur, the formula should be in C2:M2; b2 is a given amount.

 

[arthurbr]

Sorry in C2 try

=IF(C$1=$A$2;$b$2,"")
and pull right to N2

 

[sunilbsrv2k]

Hi,

Where is the source data saved? Is it in the form of a table?

arthurbr 's formula is correct. You need to put it in appropriate cell.

However, even hlookup formula also holds good if the data is available in one single row. Else it will be tedious to change row numbers in every cell.