vba - check value and vlookup, jump to next collum same row and return vlookup again

vba - check value and vlookup, jump to next collum same row and return vlookup again. If blank skip to next cell in new row

Hello Guys

I work on excel for a couple of years but only recently started to create solutions in VBA.

I need your assistence for a challenge i found.

I have the following table:
table.png

On a diferent sheet i require to "prepare" the information with a certain template.

The code value as 2 associated values "This is the data", and "This is the data2" they are never equal.

My chalenge is to vlookup the value of "code" and return "This is the data" and reaply the cenario for "This is the data2".

But "This is the data2" can be NULL. if Null the macro need to skip this cell and jump to the next "This is the data" cell and restart the process.

This is required for over 5000 values.

can you mr wizards give a hand? im strugling with this.

Thanks in advance

Can you give an example output of what you want based on the sample input above?

Your picture doesn't seem to include "This is the data" nor "This is the data2".

Attach a small sample workbook instead with just enough data to demonstrate your data. Make sure your desired results are shown, mock them up manually so we can see exactly the goal based on the sample data.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Formula in E2, copied down:

=VLOOKUP(D2, DATA!B:G, 5 + (D1=D2), 0)

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.