Forum Discussion
VLOOKUP Function failed - although everything is correct ?
RowIndex |
|
|
|
|
|
| B | C | D | E | F |
2 | Price | Fruit | Quantity | Price | Value |
3 | 23 | Banana | 50 | 0,4 | 1,00 € |
4 | 34 | Apple | 23 | 0,7 | 2,00 € |
5 | 67 | Pomegranate | 44 | 0,5 | 3,00 € |
6 | 41 | Kiwi | 79 | 0,4 | 4,00 € |
7 | 90 | Peach | 103 | 0,6 | 5,00 € |
8 | 62 | Strawberry | 71 | 0,3 | 6,00 € |
9 | 13 | Pear | 88 | 0,9 | 7,00 € |
10 | 18 | Blackberry | 39 | 0,8 | 8,00 € |
11 | 55 | Pineapple | 21 | 0,5 | 9,00 € |
RowIndex | H | I |
2 | ID | Fruit |
3 | 41 | =VLOOKUP(H3,B3:F11,2,FALSE) |
So i tried to apply the VLOOKUP Function but it failed and I dont know why because it seems to be everything correct. Any tipp or Help is appreciated.
20 Replies
Perhaps some of your values are texts and some are are numbers. Could you please share sample file instead of screenshot?
SergeiBaklan here is my file
