I trying to VLOOKUP the serial number & Description from List_tbl and add to Installed_tbl. If a serial number is available return serial, if not return "EMPTY".
List_tbl
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Installed_tbl
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>I've tried the following for the serial number but having issues.
My formula: =IF(ISERROR(VLOOKUO($G2,List_tbl!$G2:List_tbl!$G21028,1,FALSE)),"EMPTY",J2)
List_tbl
FLEET | BASE | SRD | AIRCRAFT | WUC | POSITION | UNIQUE_ID | ALT_POSITION | DESCRIPTION | SERIAL |
A-01 R | 5 | ABC | JMA0601 | 11000 | 11000 | 0 | F-15S AIRFRAME | 93-0864 | |
A-01 R | 5 | ABC | JMA0601 | 11AC0 | 11AC0 | 0 | RADOME ASSY (DOOR NO.1) (F-15SICR) | 1757 |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Installed_tbl
FLEET | BASE | SRD | AIRCRAFT | WUC | POSITION | UNIQUE_ID | ALT_POSITION | DESCRIPTION | SERIAL |
A-01 R | 5 | ABC | JMA0601 | 11000 | 11000 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My formula: =IF(ISERROR(VLOOKUO($G2,List_tbl!$G2:List_tbl!$G21028,1,FALSE)),"EMPTY",J2)