Need help with formula

[thatsjustkari]

I have an excel sheet that has numbers 1 - 20 in row 2 and various dollar amounts above them. I need a formula that if the number I put in cell D5 equals any of the numbers in row 2 it will return the dollar amount specified above it.

 

[FDibbins]

Maybe this?
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr]
[tr][td]

1​

[/td][td]

10​

[/td][td]

20​

[/td][td]

30​

[/td][td]

40​

[/td][td]

50​

[/td][td]

60​

[/td][td]

70​

[/td][/tr]

[tr][td]

2​

[/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][td]

4​

[/td][td]

5​

[/td][td]

6​

[/td][td]

7​

[/td][/tr]

[tr][td]

3​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

5​

[/td][td]

50​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]
B4=INDEX($A$1:$T$1,MATCH(A4,$A$2:$T$2,0))

 

[thatsjustkari]

That worked! Thank you so much!!

 

[FDibbins]

Good stuff, happy to help