cnatac2000
New Member
- Joined
- Sep 15, 2020
- Messages
- 9
- Office Version
- 2010
- Platform
- Windows
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
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.
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.