Help with a lookup please

[Buns1976]

Hi Everyone,
In my workbook I have Sheet "LOTTERY" & Sheet "BACKUP". In the LOTTERY Sheet I have Column E2:E70 which I need to populate based
on Column I2:I70 looking in Sheet BACKUP Column D2:D70. I am not sure how or if I can upload the workbook for you to look at but......

Thanks

 

[etaf]

you cannot attach a sheet here

you can use vlookup()

 

[Joe4]

You can attach images using the tools mentioned in Section B here: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html