On Wed, 23 Nov 2005 07:48:31 -0800, "TimM"
wrote:

I have a lookup formula and I want to do two things with it.
Formula =LOOKUP(C251,Data!B:B,Data!A:A)
When cell C251 is blank it currently returns #N/A, I would like to return a
blank cell.
Next when a number entered into cell C251 is not found in the specified
range (Data!B:B) it returns the next lowest number. (Cell Data!B:B is a list
of 7 digit numbers, but some cells contain words. Cell Data!A:A is a list of
the names assigned to the number in Data!A:A) I would like it to return just
a blank cell.

I guess it's the same problem with both, I want it be blank unless it
matches something in the list.

Wrap it up wiath an IF(ISNA) and include another test. i.e.

=IF(ISNA(OR(VLOOKUP(C251,Data!B:B,1,FALSE),LOOKUP( C251,Data!B:B,Data!A:A))),"",LOOKUP(C251,Data!B:B, Data!A:A))

HTH



Richard Buttrey
__