Trying to Convert IfError(Vlookup( formula to VBA

[kenny_g]

Hello,

I'm trying to write the following formula in VBA

=IFERROR(VLOOKUP($H5,Players!$B$1:$AB$1492,5,FALSE),0)

We use excel for a hockey pool, and each team page references the players page to retrieve the stats from many different columns. With these repetitive formula's in each cell, the workbook has become quite large. I'm hoping to write code to help alleviate some of the heavy lifting, and reduce the amount of in cell formulas

Thanks,

Cross-posted at https://www.mrexcel.com/board/thread...o-vba.1198034/

[protonLeah]

You can write a UDF using range.find; however, no sample file...

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link for you because it is your first post but please read our rules before continuing.