Worksheet Functions in vba

**kishen1912** · 10-25-2010, 09:04 AM

I am using the following statement

if worksheetfunction.iserror(worksheetfunction.vlookup(sheet1.cells(i,j).value,sheet2.range("range1"),2,0)) = true then

can you please whether this is legal... my vba compiler is crashing when i am trying this

**DonkeyOte** · 10-25-2010, 09:13 AM

Assuming i,j & range1 are all valid then perhaps:

If IsError(Application.Vlookup(sheet1.Cells(i,j).value,sheet2.range("range1"),2,0)) Then

**romperstomper** · 10-25-2010, 09:15 AM

There's nothing wrong with the syntax itself, assuming the sheets exist and the variables are correct.

**kishen1912** · 10-25-2010, 09:18 AM

How come then i am getting the following error

unable to get vlookup property of worksheetfunction class

**kishen1912** · 10-25-2010, 09:19 AM

@DonkeyoTe..

Thanks for the tip..

works like a charm

**romperstomper** · 10-25-2010, 09:22 AM

I thought you were getting a compile error, not a runtime one. The issue, as solved by DO, is that the WorksheetFunction.VLookup returns a runtime error, not an error value, if the value is not found in the table. Using Application.Vlookup returns an error value instead.