Question about Microsoft Windows XP Professional
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.
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 18, 2009 | Microsoft Computers & Internet
Feb 11, 2009 | Microsoft Excel for PC
Jul 17, 2008 | Microsoft Office Professional 2007 Full...
Jul 12, 2008 | Excel (SS8SATAS5128400R)
Jan 07, 2008 | Computers & Internet
Aug 30, 2007 | Microsoft Office Standard for PC
Aug 27, 2007 | Microsoft Office Standard for PC
73 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: