ISError with VLookup

L

locutus243

Dear Friends,

I have this VLOOKUP function in a spreadsheet -

=VLOOKUP(K2,'Full Loading List'!H:I,2,FALSE)

At the moment when there is no data entered in K2 the result of th
function shows #N/A

I know that with ISERROR I cna get rid of this, I want it use a defaul
of 100 rather than #N/A but I don't know how to word my new formula.

Can anybody out there help ???

Thanx

Mar
 
B

bcmiller

=IF(ISERROR(VLOOKUP(K2,'Full Loadin
List'!H:I,2,FALSE)),100,VLOOKUP(K2,'Full Loading List'!H:I,2,FALSE))

Alternately, your could use a range to define your error message (ie
100) and use that in your formula.

EG: Cell A1 = 100 A1 range is set to ErrorMessage


=IF(ISERROR(VLOOKUP(K2,'Full Loadin
List'!H:I,2,FALSE)),ErrorMessage,VLOOKUP(K2,'Full Loadin
List'!H:I,2,FALSE))


HTH

B
 
Top