Question about Microsoft Office Standard for PC

1 Answer

Using V llok up

Using look up to compare what figures are in one column to another and then identifying them

Posted by Smokydwason on


1 Answer

Reginald Vaz

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

Here is the formula

using V llok up - d68560d.jpg

Posted on Apr 27, 2008


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

Setting up a formula. I am comparing amounts for the last 3 years of raises and want to figure 5 different ones this year.Example of what I am trying to do. =(F6:F18*1.12%+F6:F18) Can this be done?

in excel ?
if each row has to be individually * 0.012 add a column and put in this column each row cell * 0.012. example new column G then g6=f6+f6*0.012
a screen print of what you are trying to do would give a clearer indication of exactly what you want to achieve ?

Mar 26, 2017 | The Computers & Internet

1 Answer

Round 9756 to the nearest hundredfolds

Step 1 - identify the column in question - in this case the hundreds' column is the second column, in this case the 5
Step 2 - identify the column immediately to the right of the column above - in this case, the tens' column
Step 3 - if this number is 5 or greater, we add 1 to the column in question - in this case, we add 1 to the hundreds column, making it a 6
Step 4 - if this number is 4 or less, don't add 1 to the column in question
Step 5 - set all numbers to the right of the column in question to 0

I get 9760.

Good luck.

If you have any questions, let me know.


Sep 24, 2015 | Office Equipment & Supplies

1 Answer

How to round 0.1875 to the nearest thousandth.

Step 1 - identify the thousandths column
Step 2 - identify the number immediately to the right of this column
Step 3 - if this number is 5 or more, add one to the thousandths column. If this number is 4 or less, leave the number in the thousandths column
Step 4 - set all number to the right of the thousandths column to zero.

I get 0.1880, which we normally write as 0.188.

Good luck.


May 29, 2015 | Office Equipment & Supplies

1 Answer

I have a '99 ford ranger broke a pin on shifter in steering column... when I took of cover around column it pulled a black and purple wire with a blue crescent shaped plastic clip with a copper tab out...

This is your pats transceiver. I don't know if this helps? I looked at info for 3.0L--99--ranger. You have to remove steering column cover to get at it. Also, note the wiring for transceiver. I didn't see wire color you mentioned? You might be able to go to your local dealership and talk to their service department, or call them. See if they have a transceiver in stock that they will let you look at and compare it to what you have?
pats trnsceiver-ejjpdxq2wlubfqyqthgyhwyu-4-0.jpg


Jul 08, 2017 | 2001 Ford Ranger Regular Cab

1 Answer

2003 ford explorer is stuck in park, the brake lights are on so i dont think it is something to do with the brake

adobe.gif Printable View (109 KB) TSB
Publication Date: November 1, 2004
FORD: 2002-2005 Explorer, Mountaineer ISSUE: Some 2002-2005 Explorer 4dr/Mountaineer vehicles, may require a greater effort to move the gear selector lever (shift lever) from drive to park. This may be due to a time delay with the brake shift interlock (BSI) pin retraction.
ACTION: To service, replace the BSI switch. Refer to the following Service Procedure.
  1. Remove the two (2) fasteners supporting the instrument panel knee bolster from below the steering column and remove the cover (Figure 1).

    Figure 1 - Article 04-22-12

  2. Remove the three (3) fasteners supporting the steering column lower shroud and remove the cover (Figure 2).

    Figure 2 - Article 04-22-12

  3. Remove the three (3) wiring bundle carrier fasteners from the bottom of the steering column to allow movement while removing the BSI switch. It may be necessary to release the connectors from the multifunction switch (Figure 3).

    Figure 3 - Article 04-22-12

  4. Remove the BSI fasteners (T-30 on the side and T-20 on the bottom) (Figure 4).

    Figure 4 - Article 04-22-12

  5. Pull the BSI tab on the bottom of the column downward to help free the BSI from the column housing.
  6. Break the two (2) side tabs off the BSI by the white wiring connector (Figure 5).

    Figure 5 - Article 04-22-12

  7. Push the locking tab on the white connector towards the wiring to release the connector from the BSI. Be careful not to damage the connector or wiring. If the connector does not free easily, a very small flat screwdriver may be used to help lift the locking tab (Figure 6).

    Figure 6 - Article 04-22-12

  8. Connect the wiring to the new BSI. Ensure all clips are fully engaged to prevent the connector from pulling free.
  9. Reinstall the BSI onto the steering column and reinstall fasteners (Figure 7).

    Figure 7 - Article 04-22-12

  10. Check BSI function. With the key in the accessories or run position, press the brake pedal. The BSI pin should retract on brake application, and spring up one (1) second after releasing the brake pedal. Repeat several times.
  11. Reinstall fasteners to connect wiring bundle carrier to the steering column. Make sure all connections to the multifunction switch unit are secured properly.
  12. Reassemble steering column in reverse order. Ensure rubber gap hider around shift lever is properly seated on the shroud.
  13. Cycle the shift lever from park to drive and drive back to park several times to verify improved shift effort.


Feb 15, 2011 | Ford Explorer Cars & Trucks

1 Answer

Integrated camera does not work for Z61m

press ctrl+alt+del....task manager window pops up, click on processes tab llok for you device name on the image name column, click on it and cliack on end process.

Sep 21, 2009 | Lenovo 3000V200 Laptop

2 Answers

Vlookup Syntax


I am not sure if Vlookup is the right function to use in this case.
A simpler approach may be to use an "IF" statement.

For example, with a data set:

A B 3 17 765 23 8645 45 43 87 634 635 34 31

Let assume you wanted to compare if A was greater than B and if true return B. If false return a 0.

=IF((A3-B3)>0,B3, 0)

The results would look like this:

A B Results 3 17 0 765 23 23 8645 45 45 43 87 0 634 635 0 34 31 31

Feb 27, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

25 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

13434 Answers

Lee Hodgson
Lee Hodgson

Level 3 Expert

4810 Answers


Level 3 Expert

1997 Answers

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

Answer questions

Manuals & User Guides