Replace LOOKUP formula in colunms A & C, fill to last row when entry into cell in column B

[gpato]

Hi again,

I have a workbook (attached) that has data on the worksheet 2 "DATA" and I enter data into worksheet 1 "INVENTORY" column B and use LOOKUP to fill columns A & C.

I would like the lookup formula or VBA to find last cell and fill columns A & C when there is data in column B.

Even a starting point that I can play around with would be great as I'm still green to VBA but enjoying learning how to make it suit my needs.


Much appreciated.


Sample sheet.xlsx

[Glenn Kennedy]

Is this what you ahd wanted? Just adjust the formula to get rid of the error message (#N/A) when it hits and empty cell and copy down as far as needed.

[gpato]

Thanks Glenn, works a treat

Appreciated.

[Glenn Kennedy]

You're welcome. To keep things tidy, can you mark the thread as solved & preferably say thanks by clicking the Add Reputation button at the foot of this post?