VLookup function

[matthew_lam]

Hi all,

I am using MS. Excel 2002.
I have encountered some problem with the vlookup function.
My excel file (test.xls) has got two sheets, Category and Fruit.
(I have attached the excel file for further reference)

In the Category sheet, it has got some data like these:
Column A - FruitID {1,2,3,4}
Column B - FruitIName {Banana, Apple, Orange, Melon}
Column C - NumbersInStock{12, 22, 55, 45}

And in the Fruit Sheet, it contains these data:
List {1,2,3....,11}
Fruit_Sold{Banana, Apple, ....Banana, Banana}
Fruit_ID{#N/A}

I am trying to use vlookup function to refer to the fruit_ID in the Category sheet using this formula:
=VLOOKUP(B2,Category!A$2:C$5,1,FALSE)
But it returns #N/A.

Could you help me please?
Thank you.

Matthew

[royUK]

Welcome to the Forum. Please take a few minutes to read the Forum Rules that you have just agreed to.

I will edit your thread title & move it to the correct forum

[royUK]

The lookup value has to be in the leftmost column of a table. It cannot return a value from the first column

[royUK]

See amended table 7 formulas

[matthew_lam]

The lookup value has to be in the leftmost column of a table. It cannot return a value from the first column

Thank you so much for the help, royUK.
It really works.