Hello,
I used following two formulas but not working:
I have one summary sheet with names and some of names has few spaces and other sheet is detail sheet which also have few spaces in front of names, result my vlookup function is not working. I used following but none worked
=IF(ISNA(VLOOKUP(A3,FC!A:B,2,0)),"0",VLOOKUP(A3,FC!A:B,2,0))
=VLOOKUP(A4,INDEX(TRIM(FC!A:B),0,0),2,0)
Hitachi summary has one space in the front and Hitachi in FC has 3 spaces in the front of Hitachi.
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
Thanks,
Lakeshore
<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>
I used following two formulas but not working:
I have one summary sheet with names and some of names has few spaces and other sheet is detail sheet which also have few spaces in front of names, result my vlookup function is not working. I used following but none worked
=IF(ISNA(VLOOKUP(A3,FC!A:B,2,0)),"0",VLOOKUP(A3,FC!A:B,2,0))
=VLOOKUP(A4,INDEX(TRIM(FC!A:B),0,0),2,0)
Hitachi summary has one space in the front and Hitachi in FC has 3 spaces in the front of Hitachi.
Cash summary | |
WK1 | |
Apple | 3.4 |
EMC | 2.5 |
Hitachi | 0 |
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
FC | |
Apple | 3.4 |
EMC | 2.5 |
Hitachi | 4.5 |
<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>
Thanks,
Lakeshore
<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>