Question about Computers & Internet

Ad

Are you referring to the VLOOKUP function in Microsoft Excel?

I love vlookup!

Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B:

Song# Title

123 Love Me Tender

234 Blue Suede Shoes

345 Dixie

Another worksheet has song number and performer in Row 1, Cols A:B

Song# Performer

123 Elvis Presley

234 Carl Perkins

456 Cher

Notice there is NO performer for song number 345 in the 2nd worksheet.

Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B)

Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet.

Help me out Mr. VLOOKUP.

Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0)

Copy
that cell to row 3 and row 4 Col C. You should get the performer names
for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A.

That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet.

That is why I prefer VLOOKUP over LOOKUP.

I have found this explaination of the VLOOKUP parameters helpful:

1. Needle (A2)

2. Haystack (Sheet2!A:B)

3. RELATIVE Col containing result (2)

4. Need DIRECT MATCH ONLY (0)

Hope this helps.

Posted on Jan 08, 2008

Ad

0helpful

2answers

To convert a foot measurement to a nanometer measurement, multiply the length by the conversion ratio. One foot is equal to 304,800,000 nanometers, so use this simple formula to convert:

1 ft = 304,800,000 nm

nanometers = feet Ć 304,800,000

The length in nanometers is equal to the feet multiplied by 304,800,000.

For example, here's how to convert 5 feet to nanometers using the formula above. 5' = (5 Ć 304,800,000) = 1,524,000,000 nm

1 ft = 304,800,000 nm

nanometers = feet Ć 304,800,000

The length in nanometers is equal to the feet multiplied by 304,800,000.

For example, here's how to convert 5 feet to nanometers using the formula above. 5' = (5 Ć 304,800,000) = 1,524,000,000 nm

Jan 27, 2019 •
Math

0helpful

1answer

Hide All

Percentages are calculated by using the following equation:

amount/total = percentage

Where percentage is in decimal format.

What do you want to do?

Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.

Example
The example may be easier to understand if you copy it to a blank
worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?

Example The example may be easier to understand if you copy it to a blank worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Simple way Amount/Total*100

Apr 30, 2011 •
Computers & Internet

1helpful

2answers

Hi Karthik,

Please click on the following link for recommended SCSI cards for your Fujitsu Fi-5530C2 scanner .

http://www.fujitsu.com/global/support/computing/peripheral/scanners/scsi/

Please revert for further clarification.

Thanks & regards,

TechSatya

Please click on the following link for recommended SCSI cards for your Fujitsu Fi-5530C2 scanner .

http://www.fujitsu.com/global/support/computing/peripheral/scanners/scsi/

Please revert for further clarification.

Thanks & regards,

TechSatya

Jul 26, 2010 •
Fujitsu Office Equipment & Supplies

0helpful

1answer

You can buy this from eBay which is the most easiest way. Hope I Helped. Here is the link www.ebay.com

Jan 28, 2009 •
Samsung J700 Cellular Phone

0helpful

1answer

Step1. Start Microsoft Excel 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

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.")

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

0helpful

1answer

Hello.

For cell B1 you can use this (without the quotes) "=A1"

Then for cell A2 and down you don't need a formula, but for B2 you can use this formula. "=(B1+A2)" Then click on that cell and drag the mouse down for as many cells as you want this formula to include and press Control and F keys to fill the formula down the column.

For your second formula, you would type 100 into D1 and in D2 you would use the formula "=D1-E1" (again, no quotes).

Feel free to let me know if you need any more clarification or if I missed something!

For cell B1 you can use this (without the quotes) "=A1"

Then for cell A2 and down you don't need a formula, but for B2 you can use this formula. "=(B1+A2)" Then click on that cell and drag the mouse down for as many cells as you want this formula to include and press Control and F keys to fill the formula down the column.

For your second formula, you would type 100 into D1 and in D2 you would use the formula "=D1-E1" (again, no quotes).

Feel free to let me know if you need any more clarification or if I missed something!

Jun 10, 2008 •
Microsoft Excel for PC

0helpful

1answer

See http://office.microsoft.com/en-us/excel/HP052038941033.aspx for definitive example. Thanks for rating FixYa!

Apr 19, 2008 •
Microsoft Office Professional 2007 Full...

0helpful

1answer

Hi,

MS Excel's logical test (IF) by its very nature has already two (2) "IF" conditions in a cell, "if true" and "if false".

Should you want to do a series of conditions for a single logical test of a cell, you can replace the IF TRUE and IF FALSE values with other IF Condition(s) (of course the syntax must be correct with appropriate parenthesis where and when required). Formula within a formula within a formula).

Below is an example of four (4) instances of IF conditions within the initial IF formula.

=IF(H7>4.21,H1,(IF(H7>3.4,I1,(IF(H7>2.6,J1,(IF(H7>1.8,M1,(IF(H7>0.99,O1,O7)))))))))

Hope this be of some help/idea. Pls post back how things turned out or should you need additional information.

Good luck and kind regards.

MS Excel's logical test (IF) by its very nature has already two (2) "IF" conditions in a cell, "if true" and "if false".

Should you want to do a series of conditions for a single logical test of a cell, you can replace the IF TRUE and IF FALSE values with other IF Condition(s) (of course the syntax must be correct with appropriate parenthesis where and when required). Formula within a formula within a formula).

Below is an example of four (4) instances of IF conditions within the initial IF formula.

=IF(H7>4.21,H1,(IF(H7>3.4,I1,(IF(H7>2.6,J1,(IF(H7>1.8,M1,(IF(H7>0.99,O1,O7)))))))))

Hope this be of some help/idea. Pls post back how things turned out or should you need additional information.

Good luck and kind regards.

Jan 12, 2008 •
Microsoft Office Standard for PC

1helpful

1answer

Hi,

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Dec 09, 2007 •
Computers & Internet

0answers

0answers

355 views

Usually answered in minutes!

×