Index, Match round number - ignore decimal

[tanvirabid]

Hi everyone,

I am trying to do an index, match between two columns. Both have numbers. The difference is that the numbers in the decimal are different. I am trying to find a way to ignore the decimal places i.e. round to zero places. I am using this formula:
=INDEX(ROUND(B$2:B$10,0),MATCH(ROUND(A2,0),B$2:B$10,0))
But it is not working, even as an array.
The formula would work if it only considers the numbers on the left side of the decimal.
Is there a way to do this without a support rounding column. Any ideas would be appreciated. Please see attached the image.

Thanks

 

[Toadstool]

Hi Tanvirabid,

Does this work for you?

Book2
	A	B	C	D
1	List A	List B
2	222.22	222.44		222
3	333.33	334.99		333
4	444.44	332.7		#N/A
5	555.55	333.3333		#N/A
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=ROUND(INDEX($B$2:$B$10,MATCH(ROUND(A2,0),ROUND($B$2:$B$10,0),0)),0)
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[tanvirabid]

Hi Tanvirabid,

Does this work for you?

Book2
	A	B	C	D
1	List A	List B
2	222.22	222.44		222
3	333.33	334.99		333
4	444.44	332.7		#N/A
5	555.55	333.3333		#N/A
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=ROUND(INDEX($B$2:$B$10,MATCH(ROUND(A2,0),ROUND($B$2:$B$10,0),0)),0)
Press CTRL+SHIFT+ENTER to enter array formulas.

Thanks a lot. This is perfect.

 

[Toadstool]

Thanks a lot. This is perfect.

You're welcome. Thanks for the feedback.