Post you workbook on a web postbox like http://cjoint.com/index.php and we
can check it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Dee" wrote in message
...
CLR, tried saving as an Excel 97 file... no help. Created new file
altogether, no help, saved that as a E97 file, still no help. Think I will
insert the Office disks and see if there's a repair to be made. Can't
think
of anything else. Thanks for your help.

--
-Dee


"CLR" wrote:

=VLOOKUP(A1,testrange,2)
testrange was set to A10:b22

I tried it with and without the FALSE option.......

The above worked fine in my XL97...........

Try the file on another computer, and if you still have trouble, then
the
file is at fault somehow........maybe just start with a new file....

Vaya con Dios,
Chuck, CABGx3


"Dee" wrote:

I did that before I posted and just did again to make sure. It checks
out
fine. Seems VLOOPUP just doesn't like names. Can you try it for me to
see if
your version of Excel does it correctly? Thanks.
--
-Dee


"CLR" wrote:

Go to Insert Name Define and double check the spelling and range
setting
on your Range called "testrange"..........

hth
Vaya con Dios,
Chuck, CABGx3



"Dee" wrote:

I am wracking my brain as to why the function:

=vlookup(B12|testrange|2), where the name testrange = a10:b22

fails. I have used names in formulas before, for example:

=if(homme="man"|"a guy"|"not a guy"), where homme = cell a2

and this works fine. But the VLOOKUP formul abve generates the
standard
Excel "The formula you typed contains an error. This same error
applies when
I use a single name reference as aI did with the IF function
above, as in:

=vlookup(mamma|a2:b12|2), where mamma = cell b5

Any ideas why this fails? Appreciate any help!

-- Dee