Lauren111111
New Member
- Joined
- May 1, 2020
- Messages
- 24
- Office Version
- 2013
- Platform
- Windows
I’m trying to vlookup the beginning of a cell and return a value from a table on another sheet.
E.g Luton = 5:30
But I want it to return the same value if it says Luton 2, or Luton 5
I can get this to work, but when I add more destinations and hours it stops working and find random values from elsewhere in the table even though another destination is completely different e.g Milton Keynes?? Is there a limit on the amount of data I can lookup with a partial cell? help please?
E.g Luton = 5:30
But I want it to return the same value if it says Luton 2, or Luton 5
I can get this to work, but when I add more destinations and hours it stops working and find random values from elsewhere in the table even though another destination is completely different e.g Milton Keynes?? Is there a limit on the amount of data I can lookup with a partial cell? help please?