Help so Lost with the excel =look up

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
Hi

So i got my Stock codes in cell A2-999 and in cell C2-999 all my new prices(with updated prices) and my old list in A2-999(sheet 2)in decending order .

Ok so i need to know how to make Excel take the stock codes of cell A2-999 and look up the same codes in sheet 2(A2-999) and insert the new pries for each iteam in C2-999(sheet 2)

Thanks

1 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
Hi Rawr,

Try the following formula in cell C2 of sheet2:

=VLOOKUP(A2,Sheet1!$A$2:$C$999,3,FALSE)

Now drag the formula down.

Best regards,
Trowa