coughoxford
New Member
- Joined
- Aug 3, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi , I am trying to remember a simple formula I prepared many years ago but am missing a stage ... I have a excel spreadsheet where I want a vlookup to work in cell C2 only when there is data in B2 . I have tried using = if(b2,"",(vlookup(b2,datasheet!A:E,5,false)) but it doesnt return anything even though I have checked the data is there . It will be someone thing simple but am stuck ! TYIA