Hello - I'm creating a log file to track issues from employees; I'm creating a unique ID for each issue and using this formula:
Column B2 i have =IF(ISBLANK(A2)," ",(MAX(1000)+1)) so the ID will be "Blank" until the name is added; the formula that start on B3 is (IF(ISBLANK(B17)," ")),IF(ISNA(MATCH(A18,$A$17:A17,0)),MAX($B$17:B17)+1,VLOOKUP(A18,$A$17:B100,2,FALSE)), which is causing the #Value! error...what am i doing wrong??
<colgroup><col width="215" style="width: 161pt; mso-width-source: userset; mso-width-alt: 7862;">
<col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;">
<tbody>
</tbody>
Column B2 i have =IF(ISBLANK(A2)," ",(MAX(1000)+1)) so the ID will be "Blank" until the name is added; the formula that start on B3 is (IF(ISBLANK(B17)," ")),IF(ISNA(MATCH(A18,$A$17:A17,0)),MAX($B$17:B17)+1,VLOOKUP(A18,$A$17:B100,2,FALSE)), which is causing the #Value! error...what am i doing wrong??
Employee Name | Issue ID |
#VALUE! | |
#VALUE! |