Previous Topic Next Topic

Help so Lost with the excel =look up

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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
4 Nov 2010 à 11:09
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

Similar discussions

Get an OTP from lost SIM card
FriendlyJackal37 -
boboten -

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

2 responses
Get SMS from my lost SIM card back
Ooeyemi -
HelpiOS -

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

6 responses