Hi , the following vlookup to change vlookup ranges when there is an
error
doesnt work, many thanks for any help


Function taz(a)
On Error Resume Next
taz = WorksheetFunction.VLookup(a, Range("a1:b3"), 2, 0)


If IsEmpty(taz) Then
taz = Worksheet.Function.VLookup(a, Range("a10:b12"), 2, 0)

End If

End Function


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=505673