For an exact match
=VLOOKUP(A1,[Item.xls]SheetName!A2:C4,3,FALSE)

The above returns #N/A if no match


To find the largest value < lookup value
=VLOOKUP(A1,[Item.xls]SheetName!A2:C4,3)


Substitute SheetName with the name of the worksheet containing the
lookup table.

Better to use a named range

=VLOOKUP(A1,[Item.xls]SheetName!yourNamedRange,3)





?B?cG9s?= wrote in
:

I have two worksheet. How I can locate the corresponding price in
item.xls and to write in price.xls. Please help

1. Item.xls
2. price.xls

Item.xls
A B C
Code, description, rate
001 TV 12
002 COMPUTER 5
004 RECORD 6

Price.xls
A B
code rate
001 12
003 0
004 6






--