LOOKUP question

[bdunk]

I am trying to perform a lookup. I have a table with lookup info to th
left column. I have lookup information in column A. I am trying t
match the info from column one of my table to Column A or the sheet an
when found insert column 3 of my table. My sheet has old and new price
however there are new parts so the rows do not match up part for part.
I need the matching part numbers Column A and column 1 of my table t
be matched and when done to insert the value in column 3 of the par
which is price into the appropriate cell. Can this be done. What am
doing wrong.

I am currently using this formula:=VLOOKUP(A4:A428,G$4:I$549,3,FALSE

 

[Frank Kabel]

Hi
try:
VLOOKUP(A4,G$4:I$549,3,FALSE)
and copy this down for all rows