search sheet to get info on another

[jj33002]

Hello Everyone,

I have two different worksheets. The first sheet is like a master list
of items. It also contains the prices for the items listed. The items
are in column A and the price is beside it in column B. The second
sheet is a list of items that the user has to enter in to be used for a
job. The user has to go through and enter in the item in column A that
he wishes to use for the job. Is there any way that you can take what
the user puts in on the second sheet and search the first sheet so that
the prices will be entered beside the items that the user put in? I
have tried several things and I am not even getting close.

 

[evgny]

Hi JJ3302

try vlookup function

regards
Yngve

 

[jj33002]

hey,

the only problem that i have with the vlookup is that the info that the
user is entering in will change all the time. I need a macro that will
just search each cell in column A on sheet 2 and find that word in in
column A in sheet 1, then take the price from sheet 1 column B and put
it in sheet 2 column B beside that word.