Problem with Match function when lookup data is in another sheet

[cnatac2000]

I want to create a match formula where the lookup data is in another sheet.

For example, I want to look or match the amount of 4,407.72 in Sheet called "Look", row 7

the look up value in the tab called "Data" starting from row B1 to B3

4,407.72

4,507.00​

4,508.00​

My formula array on c9 is not working. It won't even let me complete the formula array. From the data, it should see a row with a value of 4407.72, since the integer value of it is 4,407.72.

=MATCH(C7,data!INT(B1:B3),0)

Any help would be much appreciated.

 

[Wookiee]

Looks like you misplaced the INT function. I placed it first in the MATCH function and it worked for me.

=MATCH(INT(C7),Data!B1:B3,0)

 

[Fluff]

Maybe

=MATCH(C7,INT(data!B1:B3),0)