Vlookup Help (Need to do ISNA and a few IFs within one function)

Basically I have a column where there are 1.) numbers (e.g., 38001), 2.) -'s ([ - ]), and 3.) #N/As. I want a function to return ONLY the numbers, i.e., if it has -'s or #N/A's, then return "". So far I can only think of functions that do one or the other, not both. Any tips??

You are right.. I should have just done that.. here is what I did end up with though (the really hard way)

=IF(B:B = "-","",IF(ISERROR(VLOOKUP(B8,'Sheet1!$G$6:$H$649,2,0)),"",VLOOKUP(B8,'Sheet1'!$G$6:$H$649,2,0)))

Hi,

Assuming your numbers are really numbers (and not string numeric characters) then why not just preface your VLOOKUP with an =ISNUMBER() function. e.g.

Formula:

Please Login or Register  to view this content.