Question about Microsoft Excel for PC
I need a formula that will do the following:
I need the description from one sheet to be allocated to another sheet when inputting the stock code. How do I write this formula? Doi use IF & lookup? I am totaly lost at this point!!!!!!!!
in my opinion the best solution is to use vlookup. it is simple but very very powerful. the only drawback is that you should have unique code for stock codes i.e. no duplication is allowed in the main sheet . for example you should have a small data base of two columns in a separate sheet say sheet1 the frist clomn a is for the code and the second column b is for the description.
and you go to the search sheet beside the cell that you write in the code say a1.write in b1 =vlookup(a1,sheet1!a:b,2,false). this should end your problem isa.
Posted on Oct 20, 2008
Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.
Posted on Oct 17, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 05, 2011 | Computers & Internet
Sep 28, 2010 | Google Computers & Internet
Sep 01, 2010 | Computers & Internet
Aug 06, 2009 | Acomdata 1TB Puredrive USB Esata 1 TB Hard...
Dec 07, 2008 | Casio Parts Cash Register PC Desktop
Nov 16, 2008 | Onkyo TX-SR606 Receiver
May 26, 2008 | ASUS A8V-MX Motherboard
Mar 24, 2008 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
140 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: