Book1.xlsx
I have read several posts and spent several hours trying to do this so I am desperately hoping someone can help
I have 2 sheets and I am trying to put the values in column B from sheet 2 in to column B in sheet 1 based on the booking references (Column A in both sheets)
Please can you advise what formula I need to use, I have tried if and match and vlook up but just don't seem to be able to get it to work.
![]()
Bookmarks