scohn80215
New Member
- Joined
- Mar 16, 2018
- Messages
- 9
Wait, that doesn't make sense. Your lookup range is just a single cell.
So for that, I would do
=IF(LEFT(cell,9)=B2,B2,"")
What would your plain vlookup look like if you didn't have to be concerned with only the left9 ?