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?

	A​	B​	C​	D​	E​	F​	G​
1​	10​	20​	30​	40​	50​	60​	70​
2​	1​	2​	3​	4​	5​	6​	7​
3​
4​	5​	50​

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