LOOKUP question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bdunk - 29 Oct 2004 16:36 GMT

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

Reply to this Message

Frank Kabel - 29 Oct 2004 16:54 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I am trying to perform a lookup. I have a table with lookup info to the
> left column. I have lookup information in column A. I am trying to
> match the info from column one of my table to Column A or the sheet

and

> when found insert column 3 of my table. My sheet has old and new prices
> 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 to
> be matched and when done to insert the value in column 3 of the part
> which is price into the appropriate cell. Can this be done. What am

> doing wrong.
>
[quoted text clipped - 5 lines]
> bdunk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=508
> View this thread: http://www.excelforum.com/showthread.php?threadid=273630

Reply to this Message