| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero on the left !!!
I have cells with numbers like this, 012345678 or 001234567, I formatted all
cells with this function =text(cell,"000000000") so that the zeros are not cancelled,which is good,my problem was this: a1=012345678 ,b1=012345678, c1=Shop Stock. =if(a1=b1,"yes","no") the result was yes. =if(isna(vlookup(a1,b:c,2,0)),"????",vlookup(a1,b: c,2,0)) the result was ???? and it should be Shop Stock !!!!!! Could someone help, Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make left side stay still and right side can move left to r | Excel Discussion (Misc queries) | |||
| My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
| worksheet is right-to-left but i want left-to-right...? | New Users to Excel | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Threaded Mode
