Question about Microsoft Windows XP Professional

1 Answer

Some cells return #N/A

I am using a very simple vlookup formula: =VLOOKUP(H53,PROV,2,FALSE). The majority of the lookup data is recovered and placed in the proper cell. However, some of the cells are returning a #N/A error. I have checked to see if the lookup data is in the reference data. I have tried reformatting the cells to no avail.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

The issue is that you may be trying to find the the data which is not there in the table PROV hence you need to have a look at the data in the table PROV
first see if the data you are trying to find is there in the table or not (use crtl+f) to see if the data is there in the table.

Posted on Dec 18, 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:

9 Answers

Data Recovery Software


Maybe you can try uFlysoft Data Recovery for Mac, it can recover empty trash on Mac only in three steps:
Step 1. Launch the software to scan the device where your files deleted
Step 2: Preview the scan result files and make mark if it is the one you find
Step 3: Recover files

Mac Data Recovery Recover Lost Data with Ease

Jun 06, 2015 | Data Recovery Software Computers &...

5 Answers

Corrupted files from usb, how do i recover?


click start control panel administrive tools computer management disk management right click on your drive select properties click tools you should see click check now click start two boxes

automatically fix files and scan for and attempt recovery of bad sectors place then a tick in one box then select check now start then after its finished return and tick the other box you should not

do anything while the chkdsk utility is in progress any input may damage this drive
i have found the best results ticking in one box the returning after it has finished then ticking the other box

it might take some time depending on the size of your disk but be patient

hope it helps

Sep 17, 2012 | Data Recovery Software IdeaPad A2109 ...

4 Answers

How to recover corrupted files from my computer


Maybe you can try uFlysoft Data Recovery for Mac, it can recover empty trash on Mac only in three steps:
Step 1. Launch the software to scan the device where your files deleted
Step 2: Preview the scan result files and make mark if it is the one you find
Step 3: Recover files

Jul 30, 2012 | Microsoft Windows XP Professional

1 Answer

How to calculate the percentage using the excel



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.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. 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.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
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.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. 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

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

Requesting solution for my problem in excel


sound card driver missing
Windows XP and Realtek AC97 audio drivers

Jun 11, 2008 | Microsoft Windows XP Professional With...

1 Answer

Vlookup


You know, you really should have said it's an Excel problem, because it is; also your invoice and receipt numbers should probably be 10-12 digits long (yes, even if you do a mere 20 deals a year).

Add error checks and alerts to your spreadsheet, for starters; second, state the version etc. of the spreadsheet program you use, and how much memory is available on your system. VLookup often bombed or just gave the last result forever if it didn't have 130MB to play with. Other times it behaved if you ran certain initializations for it....

Mar 23, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Windows XP Professional Logo

Related Topics:

73 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 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...