vlookup iserror with autofill to dynamic range - changing array/col index

Hi all

first off I apologise as I am struggling to explain what I want to do:

I am trying to do vlookups (excel 2010) with the result of "unknown" if there is an error on a column of varying length, autofilling to the last row of adjacent column.

The current code I have works fine, however I want to include this in a loop where the vlookup values/array/column index number change depending on which worksheet the value has been taken from. I have tried to use application.vlookup and application.worksheetfunction.vlookup in the past but autofill only fills the first value not its formula.

Please Login or Register  to view this content.

any idea how I can use vlookup (including an 'unknown' on error) that I can assign preset values for the table array and index number that can be autofilled down a column of varying length?



thank you for trying to understand my question!

Suggest you add code tags before you get "moderated". In the meantime, I'll have a look at it ...

Code tags please, before I can provide a possible solution.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Thanks for complying with the rules ... resistance is futile

Please Login or Register  to view this content.

Regards, TMS