=VLOOKUP(A2,STOCK260903.xls!$A$2:$G$3854,7,FALSE)
I want it to say "No match" in replace of #NA using ISNA
How can i implement this?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/26/2003 Rating: 9.2 Views: 0
Hi
I have a worksheet that has several hundred rows of data with 3 columns. The first column is an alphanumeric code which describes which group the rest of the row belongs to. For example:
C...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/07/2006 Rating: 7.8 Views: 0
Hi,
In my spread sheet my cells may have a value of ZERO (0) (although the column is formatted to date), or #N/A, or an actual date value. In the first two scenarios I want the displayed values ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/19/2007 Rating: 9.6 Views: 4
I would like to lookup from 1 query to another by customer number and have it return the customer # or a NotHere response but I do not know the sintax. In Excel it would be
=IF(ISNA(VLOOKUP(A19...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24544080.html
