=if(isna(vlookup($a2,absol_pr,1)),"",vlookup($a2,absol_pr,6))
You must be an old Lotus user. Excel doesn't require that + sign near the
beginning:
More likely he just has the same habit that I have. To signify a
formula you can do an [=] sign or a [+] or [-] sign. However the [=]
key is a standard sized one which is bordered by four others in a
remote part of the keyboard (relative to where your fingers usually
are). The [+] key on the numeric keypad, however, is twice the size of
a normal key and has nothing but open desk out to the right of it.
When I'm typing functions rapidly (particularly when there is a lot of
numeric content and my hand spends most of the time on the keypad),
going for that key rather than the = one just reduces the likelihood
of a tyop. Sometimes I go through and tidy up with a search and
replace later, but that's purely aesthetics; it makes no difference to
the formula. (Actually if it's a purely numeric expression (one
without functions), Excel will do the replacement of the symbol itself
anyway.)
=+if(...
And I don't think Lotus required it either (@if(...)???). [Snip]
Roger said:
I'ne been trying to eliminate the N/A in this formula, but to no avail
=+IF($A2=VLOOKUP($A2,absol_pr,1),VLOOKUP($A2,absol_pr,6)," ")
