At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
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.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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
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.
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
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.
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.
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
×