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