Hi All,
Would need your help on this!
I got the data as below:
Data
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>
What I want to do is to vlook-up both data above with a summary table. I have tried to use CIDEMPRM? in the summary table but couldn't get a result (e.g.: #N/A).
Please advice how I can solve this. My thinking is to have the summary table with CIDEMPRM and the last character can be anything so that when vlookup, any numerical numbers can be identified via the summary table.
Hope that is clear!
Thanks!
Eujin
Would need your help on this!
I got the data as below:
Data
CIDEMPRM1 |
CIDEMPRM2 |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>
What I want to do is to vlook-up both data above with a summary table. I have tried to use CIDEMPRM? in the summary table but couldn't get a result (e.g.: #N/A).
Please advice how I can solve this. My thinking is to have the summary table with CIDEMPRM and the last character can be anything so that when vlookup, any numerical numbers can be identified via the summary table.
Hope that is clear!
Thanks!
Eujin