wonderfulsomebody123
New Member
- Joined
- Jan 13, 2021
- Messages
- 20
- Office Version
- 2007
- Platform
- Windows
{=LOOKUP(2,1/("0"=LEFT(B:B,1)),A:A)}
The above formula doesn't catch on to the leading zeros that are displayed in B:B cells. I understand that making B:B cells with custom formatting as 00 only displays the leading zeros for me to see but I want to make Excel include those zeros when using formulas. How?
I tried {=LOOKUP(2,1/("0"=LEFT(TEXT(B:B,1)),A:A)} but that doesn't work.
Please help, thank you!
The above formula doesn't catch on to the leading zeros that are displayed in B:B cells. I understand that making B:B cells with custom formatting as 00 only displays the leading zeros for me to see but I want to make Excel include those zeros when using formulas. How?
I tried {=LOOKUP(2,1/("0"=LEFT(TEXT(B:B,1)),A:A)} but that doesn't work.
Please help, thank you!