How to continue UDF after error and at last error should result in blank in case-no result

I created a UDF which is doing vlookup from two worksheets in same workbook and some values are not there, so UDF result in #Value error. now my idea is to adding 3rd worksheet for remaining values vlookup from there. and how can i end UDF result as blank instead of #Value error

Please Login or Register  to view this content.

now where above UDF not get values from Sheet"A" & Sheet"B", it should get values from Sheet"C".
and still no values found from A,B,C then cell should result "". Blank only.
please support

Replace all Application.WorksheetFunction.VLookup with Application.VLookup.

Application.WorksheetFunction.VLookup raise the run-time error when nothing to return so, IsError function will not work.
And also you can get rid of all Error handler.

jindon thanks for teach me this i have corrected in code in attached sample file from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Richard Buttrey : Here now i have attached a sample file, in this you will find sheets a,b and c have some data and sheet("data")
is having calculations for column B which is doing vlookup and some cleaning and some more data requirement manipulation.
myudf, i had prepared for two parameters : sheets"a" & sheets"b" but now i need to add third parameter in myudf.

Thanks in advance

1) Use in cell like
G2:
=IFERROR(MyLookUp(B2,A!$U$2:$AN$19,20,B!$U$2:$AZ$19,19,'C'!$B$2:$AZ$19,14),"")
Where B2 = search value
the rest are the parameter array, set of LookUp Range, reference column index and you can add more if you need to.

2)

Please Login or Register  to view this content.

1) Depends on how you use it.
2) Understanding parameter arrays (VBA) | Microsoft Docs
3) UBound function (Visual Basic for Applications) | Microsoft Docs
4) CVErr function (Visual Basic for Applications) | Microsoft Docs