Hi Ernie

Vlookup has 4 parts
VLOOKUP(A2,Tariff!$A:$B,2,0)
Item to lookup A2
Table to look in Tariff!$A:$B
Offset from found item 2
True or False (or 0 or 1) 0 (False)
False allows for the table to be unsorted, and ensures that an exact
match is found.

In the formula I gave you, you wanted the value from column B, or an
offset of 2.
Now you want values from column I, so first you must make the size of
the table bigger, and be
Tariff!$A:$I
and change the offset to 9.
You now know how to pick up any of the values from your table.

--
Regards

Roger Govier


"ernie" wrote in message
...
hey Roger.. it works perfectly now.. thanks alot..
now i'm wondering how i'm gonna get this one to work.. heres the
situation:
how do i make the appropriate ImportDuty to display with my item code?
the item code is in columnB while the ImportDuty is in columnI.
heres the example:

columnB | columnC | D | E | F | G |
H |
columnI |
item code | description | | | |
|
| importDuty|
row5 te35434 | nissan brake pad | | | | |
|
20% |
row6 eos920 | poineer mp3 player | | | | |
|
10% |
--
help a friend help you


"Roger Govier" wrote:

Hi Ernie
Try

=IF(A2="","",IF(ISERROR(VLOOKUP(A2,Tariff!$A:$B,2, 0)),"",VLOOKUP(A2,Tariff!$A:$B,2,0))



--
Regards

Roger Govier




ernie wrote
it works just fine when the worksheets are named sheet1 and sheet2
and i am having difficulties fixing it.
my sheets are named 'Tariff' and 'Data Input Sheet'.
i have the codes and description on the 'Tariff' worksheet. i need
the description to appear in 'Data Input Sheet'
it starts from row5 and column B in both worksheets
Example of what it looks like:
columnB | columnC
item code | description
row5 te35434 | nissan brake pad
row6 eos920 | poineer mp3 player
arrange the formula so it works with this setting for me please..
thanks you in Advance..