VlookUP included in two conditions in a if&ISNA formula

[davidfla90]

Hey,
I want to check a cell to see if its in the look-up table and if its a number

If not in the lookup a table or a number, "false" will be outputted.

So far I have a formula to check if the cell is in the look-up table

=IF(ISNA(VLOOKUP(B395,SNN_Database!$A$2:$A$243,1,FALSE)), "False", "True")

And to check if its a number:

=ISNUMBER(A2), "True", "False"

How do i combine these?

 

[marka87uk]

Use
=IF(AND(ISNA(...),ISNUMBER(...)),...