Previous Topic Next Topic

Help so Lost with the excel =look up

Closed
Rawr - Nov 4, 2010 at 04:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 4, 2010 at 11:09 AM
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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 4, 2010 at 11:09 AM
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
0

Similar discussions

Sim card lost how to get otp message without old sim card
Sadik_786110 -
jone_7896 -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
I can't get the code because the sim has lost
Gloria -
Francine -

2 responses