Hi Guys I am trying to search using the LOOKUP function but I found the wrong value , example:
row a b
1 60,00 1,103
2 60,10 1,099
3 60,20 1,096
In the cell c3 I calculate (6,2 * 10)
In the cell c4 I make =lookup(c3;a1:a3;b1:b3)
But the cell c4 shows 1,099, and the right answer is 1,096 , someone can help me , please.
Bookmarks