You've missed a couple of brackets - try this:

=IF(ISNA(VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE))," ",VLOOKUP(F6,Data!$A
$93:$B$101,2,FALSE))

Hope this helps.

Pete


On Jul 26, 2:32 pm, LTaylor wrote:
=VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE)

Above is my formula for the cell and I'm trying to make it so the #NA
doesn't show up but I must not be doing your formula correctly because I keep
getting an error. Here is what I was putting:

=IF(ISNA(VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE),"
",VLOOKUP(F6,Data!$A$93:$B$101,2,FALSE)

Also I'm still trying to get the other issue with more than one result going
into two different cells but I'm not having any luck yet.



"Gord Dibben" wrote:
I don't see your 2:00pm post Alan.

Downloaded headers back to this AM but still can't see it.

Google is a mess right now so didn't search there.

Gord

On Wed, 25 Jul 2007 18:06:02 -0700, LTaylor
wrote:

You are great. Thank you, thank you, thank you!!!

"Alan Beban" wrote:

Gord Dibben wrote:
You need two VLOOKUP formulas in two cells.

uh-uh.

=VLOOKUP(D2, $A$2:$C$3,2,FALSE) entered in E2

=VLOOKUP(D2, $A$2:$C$3,3,FALSE) entered in F2

You missed my post of 2:00pm? The equivalent of

=VLOOKUP(D2, $A$2:$C$3,{2,3},FALSE) array entered in E2:F2

Alan Beban- Hide quoted text -

- Show quoted text -