Lookup function gives wrong answer only for the last row.

[varath]

The lookup formula is giving wrong answer only fir the last row.

In the example photo given, I want to search for fruits given as reference from one column into other column and output the price.

All other answers are correct. But only last row gives wrong answer.
Can someone please help?

It would be greatly appreciated.

 

[Fluff]

For lookup to work the data needs to be sorted ascending.

 

[jkpieterse]

Change your formula from LOOKUP(...) to XLOOKUP(...) and you should be good to go

 

[varath]

Attaching another photo, as row number is not visible in previous one.

Change your formula from LOOKUP(...) to XLOOKUP(...) and you should be good to go

It might work. But I am solving this for a test. They have asked to use LOOKUP obly.

 

[Fluff]

If you have to use Lookup, then you will need to sort the data.

 

[varath]

If you have to use Lookup, then you will need to sort the data.

Okay. Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.