if(isnumber - issue

[bluepenink]

Hello thxs and finally, i keep getting an error with the formula below


=if(ISNUMBER(vlookup(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,false)))

pls advise, thx you!

 

[T. Valko]

Hello thxs and finally, i keep getting an error with the formula below


=if(ISNUMBER(vlookup(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,false)))

pls advise, thx you!

Is there more to the formula?

Looks like some of it didn't get posted.

 

[Andrew Poulsom]

Is this what you want?

=IF(ISNUMBER(VLOOKUP(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,FALSE)),VLOOKUP(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,FALSE),"")

 

[taurean]

You have not defined (True / False) cases like:
=if(ISNUMBER(vlookup(C2,'OFFICE MAX -Invoices'$C$2:$N$3379,12,false)),"NUMBER","ELSE")

 

[bluepenink]

Is this what you want?

=IF(ISNUMBER(VLOOKUP(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,FALSE)),VLOOKUP(C2,'OFFICE MAX - Invoices'!$C$2:$N$3379,12,FALSE),"")

great, thx you so so much.

i was caught off guard that i had to repeat the formula again, thx you!