Question about Computers & Internet

1 Answer

Excel working on Excel for school. Book instructs to use a "look up function to have the product name and price name automatically entered into the sales form when the product ID is entered. Then says: hint ; cells should be blank if an error value appears in a cell.Can you help?Thanks,

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 85 Answers

I THINK what he is trying to say

you do not want the cell on the sales form to show an error message, instead not to show anything. It has been awhile for excel but i believe if you right click the cell and goto properties you can change what it should show.

Posted on Nov 13, 2007


1 Suggested Answer

  • 2 Answers

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

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

Excel cell replacement

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)
This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

1 Answer

Excel Loan to Value function format

Where Cell1, Cell2 and Cell3 are the cell references for the 1st, 2nd and 3rd loan fields and the sold price is the field reference for the cell that has the value for the sold price in it.

Apr 18, 2009 | Microsoft Excel for PC

2 Answers

Word makes a duplicate file automatically

Check TOOLS --> OPTIONS on the SAVE tab. See if "always make a backup copy" is checked.

Feb 10, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Excel lookup - match index array

The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

1 Answer


Step1. Start Microsoft Excelmag-glass_10x10.gif and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. $('.Article .Steps .Image').each(function(i,e){ e = $(e); e.find('img').error(function(){ $(this).unbind(); e.remove(); }); });
Tips & Warnings
  • Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
  • Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Help I dont know mutch of excel

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

1 Answer

Excel question

You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Aug 19, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel formula help

formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

3 Answers

Excel password removing

could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Exel 2003

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (!) to the cell reference. In the following example, the AVERAGE worksheet function calculates the average value for the range C1:C10 on the worksheet named Marketing in the same workbook.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

55 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides