Iferror + If + Index + Match in VBA

Hi All,

I need help to translate the two formulas below into VBA.

Thanks a lot for your help.

Formula 1:

Please Login or Register  to view this content.

Formula 2 :

Please Login or Register  to view this content.

Originally Posted by Kaper

...And what shall be done with the result?
If it is to be stored in a cell where formula would reside, probably easiest approach is to write there formula and then store as value. Note single quotation marks replaced by double:

Please Login or Register  to view this content.

if it is to be stored in variable use
start with something like

Please Login or Register  to view this content.

edit: first question is of course the same as above. But I started writing a bit earlier, it just took me few minutes to write the code :-)

Thanks a lot. My sheet has hunderds of thousands of rows therefore, vba is a better option rather than writing a formula for each cell.

Originally Posted by xlnitwit

Hi,

What do you mean by "translate to VBA"? How do you intend to use them and why is a formula not a viable option?

See above.