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)," ")

Can some one help me plse

Roger

=IF(ISNA(VLOOKUP($A2, absol_pr, 1)), "", VLOOKUP($A2, absol_pr, 6))

Just watch your VLOOKUP statements. You're not getting an exact match.
Try: VLOOKUP($A2, absol_pr, 1, FALSE)


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Roger March" wrote in message
news:Mt0Ic.998991$Pk3.186810@pd7tw1no...
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)," ")

Can some one help me plse

Roger

=if(isna(vlookup($a2,absol_pr,1)),"",vlookup($a2,a bsol_pr,6))

You must be an old Lotus user. Excel doesn't require that + sign near the
beginning:

=+if(...

And I don't think Lotus required it either (@if(...)???).

And just a word of warning. If you want cells to look empty, you might be
better served by using:

""
instead of
" "

It makes things a little easier down the road.

=if(a1="","one thing","or another")



Roger March wrote:

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)," ")

Can some one help me plse

Roger

--

Dave Peterson

On Sat, 10 Jul 2004 20:27:04 -0500, Dave Peterson
wrote:

=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 March wrote:

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)," ")

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *