Question about Microsoft Excel for PC

2 Answers

LOOK UP AND ALLOCATE

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

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Hi hi

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.

good luck

Hussein

Posted on Oct 20, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 1,183 Answers

Hi,
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.


Thanks
Proton

Posted on Oct 17, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi i m using gateway nv55c03u. its using intel hd graphic.I know its integrated. is there anyway i can allocate more ram to the graphic card?or is it possible i cn put another card in?


if tehre is an ability to allocate more memory that feature would be in the BIOS otherwise you will have to stick with what you have

Jun 05, 2011 | Computers & Internet

1 Answer

I am unable to create a company after installing tally 9 v 2.14 on my system. On clicking create company option in gateway there is an error message sayin\r\n " Exiting Tally! Error in TDR. 'Part:Basic...


I am unable to create a company after installing tally 9 v 2.14 on my system. On clicking create company option in gateway there is an error message sayin\r\n " Exiting Tally! Error in TDR. 'Part:Basic Company' Insufficient Height to Allocate" please help

Sep 28, 2010 | Google Computers & Internet

1 Answer

Math Problem: You have an upstream Picking department that feeds two downstream packing departments: A and B. 75% of your Pick volume goes to department A, which has a packing rate of 150 unites per labor...


Stream
Vol %
Units/Hr
Total Volume
Hrs Reqd
Staff Reqd


Pick
1
100
=(D3*B2)/B3
=D2/C2
=E2/10


Pack A
0.75
150
7500
=D3/C3
=E3/10


Pack B
0.25
25
=D2-D3
=D4/C4
=E4/10



Paste this in an Excel Spread sheet. After pasting it press CTRL+~.

Sep 01, 2010 | Computers & Internet

1 Answer

My hard drive is recognized but won't open on my win xp pc. everything runs slow when i have it on. back to normal instantly when turned off. please help.


may be your xternal hardrive wasnt alocated..

try to allocate it

start>my computer (right click select manage)>click disk managment ( look at the right area below) > see the black line with non allocated> right click then allocate > select extended then next .. the black line will turn into green.. you hard drive now could recognized with your pc.

Aug 06, 2009 | Acomdata 1TB Puredrive USB Esata 1 TB Hard...

1 Answer

'97 BMW 318i headlights hesitate


REPLACE THE HEADLIGHT FUSE IN THE FUSE BOX TO ALLOCATE THE RELAY SWITCH ON THE LIGHTS AND WHEN IT IS ON REMOVE THE RELAY ONE BY TO ALLOCATE THE RELAY .REPLACDE THE FAULTY RELAY

May 02, 2009 | 1997 BMW 318

1 Answer

How do I allocate PLUs to departments on my CASIO TK-7000?


take a readout of the department and groups first
pgm6
205 subtotal
1 cash 30 cash
this will print out your departments

pgm6
206 subtotal
this will print out your groups

pgm3
1166 subtotal
enter your 6 digit number then press all the products linked to that department / group

your 6 digit number = DDGG00 DD= Department GG= Group
then 00
so for dept 1 gp 1 = 010100

when finished
press subtotal

Dec 07, 2008 | Casio Parts Cash Register PC Desktop

1 Answer

Onkyo tx-sr606 can not get it to work w tv using hdmi cables


try using a HDMI cable connecting the receiver from the "out" to the tv, then allocate through the setup menu what you have connected, say a cable box by hdmi, you would go to cable/sat allocate the port "hdmi1 or coax 1" then return. If it is a dvd click on dvd then allocate eg: "hdmi 2" then return.

Nov 16, 2008 | Onkyo TX-SR606 Receiver

2 Answers

Doesnt support graphics


Sounds like you need to allocate more RAM to the on-board graphics. Allocate at least 128MB.

These folks did a benchmark using Halo among other software, so it should work.
http://www.digital-daily.com/motherboard/via_vs_ati/index3.htm

But the on-board graphics performance on your board is quite poor - you should consider getting a decent AGP graphics card instead of using the on-board graphics for gaming.

May 26, 2008 | ASUS A8V-MX Motherboard

1 Answer

Formaul


you have to use the reference Do you know how to use it

Mar 31, 2008 | Microsoft Excel for PC

1 Answer

Unable to Install Red Hat Linux Enterprises 4


when the time of installing only you have to take linux boot loader then it will show both operating systems otherwise i think the problem is monitor configuration in linux installing

Mar 24, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

138 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...