Hello,

I am working in Excel XP pro. I have the following string of code in a cell.

=IF(QUOTE!B17="","",VLOOKUP(QUOTE!B17,TaskList,2,F ALSE))

At the bottom of the page is the named range TaskList. It is two columns and
around 100 rows. Currently, one the first 25 are used. The rows are below.

Task abbreviation
Cutting machine MCHCUT
painting machine MCHPNT
stapling machine MCHSTP

clean up TSKCLN
sanding TSKSND
grind and prime TSKGNP

The groups are spaced for easier use. Things are grouped together in order
to make searching easier. There is a ton of extra rows in the named range so
that other entries could be added as they were needed.

I went to the named range and added another entry below the ones above. That
entry has one empty row between it and the one listed above.

design TSKDSN

the quote sheet has a drop down list in cell B17. That list comes from the
tasks column to insure that the entry matches exactly with the entry in the
named range. Selecting any of the original six options causes the formula to
return the correct TSK entry. Selecting design returns #N/A. I tried
replacing on of the existing entries with design. If I make a change then
the cell again returns #N/A.

Why is this failing to work? Any ideas will be appreciated.

LWhite

Since you have selected "FALSE" the #N/A means no "EXACT" match was found

check for trailing spaces in either of your entries

IF so then you may need to use a drop down box to Validate B17 selection

"L.White" wrote:

Hello,

I am working in Excel XP pro. I have the following string of code in a cell.

=IF(QUOTE!B17="","",VLOOKUP(QUOTE!B17,TaskList,2,F ALSE))

At the bottom of the page is the named range TaskList. It is two columns and
around 100 rows. Currently, one the first 25 are used. The rows are below.

Task abbreviation
Cutting machine MCHCUT
painting machine MCHPNT
stapling machine MCHSTP

clean up TSKCLN
sanding TSKSND
grind and prime TSKGNP

The groups are spaced for easier use. Things are grouped together in order
to make searching easier. There is a ton of extra rows in the named range so
that other entries could be added as they were needed.

I went to the named range and added another entry below the ones above. That
entry has one empty row between it and the one listed above.

design TSKDSN

the quote sheet has a drop down list in cell B17. That list comes from the
tasks column to insure that the entry matches exactly with the entry in the
named range. Selecting any of the original six options causes the formula to
return the correct TSK entry. Selecting design returns #N/A. I tried
replacing on of the existing entries with design. If I make a change then
the cell again returns #N/A.

Why is this failing to work? Any ideas will be appreciated.

LWhite

I am using a drop down box to insure that this is an exact match.

Furthermore, as a method of testing I tried deleting the value in a working
cell and entering a single letter. Then using the drop down list to select
that letter. Same result.

LWhite

"Vacation's Over" wrote in message
...
Since you have selected "FALSE" the #N/A means no "EXACT" match was found

check for trailing spaces in either of your entries

IF so then you may need to use a drop down box to Validate B17 selection