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 555
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

Similar discussions

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

Hi, Sim card lost now unable to get otp have no source for same number to get can I get otp on another number of that old sim plz suggest ...

2 responses
Get an OTP from lost SIM card
FriendlyJackal37 -
boboten -

Hi, I have lost my sim card. How to get an OTP? Please help!

1 response
Unlock my otp messages
Ohluma -
HelpiOS -

Hello, Simcard lost how can I get my otp messages without it

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
My sim card lost I can't receive code
Stanley -
boboten -

Hello, I lost my sim card number and those numbers I used for Facebook security now I lost it I can't receive the codes

1 response