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
| 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 |
Installed_tbl
| FLEET | BASE | SRD | AIRCRAFT | WUC | POSITION | UNIQUE_ID | ALT_POSITION | DESCRIPTION | SERIAL |
| A-01 R | 5 | ABC | JMA0601 | 11000 | 11000 | 0 |
I've tried the following for the serial number but having issues.
My formula: =IF(ISERROR(VLOOKUP($G2,List_tbl!$G2:List_tbl!$G21028,1,FALSE)),"EMPTY",J2)
Hello,
Change the lookup section in your formula to VLOOKUP($G2,List_tbl!$G2:List_tbl!$J21028,4,FALSE).
You need also to replace the J2 reference with the VLOOKUP formula in above line.
Complete formula should be =IF(ISERROR(VLOOKUP($G2,List_tbl!$G2:List_tbl!$J21028,4,FALSE)),”Empty”,VLOOKUP($G2,List_tbl!$G2:List_tbl!$J21028,4,FALSE))
Or, if you are using Excel tables. =IF(ISERROR(VLOOKUP($G2,List_tbl[[UNIQUE_ID]:[SERIAL]],4,FALSE)),”Empty”,VLOOKUP($G2,List_tbl[[UNIQUE_ID]:[SERIAL]],4,FALSE))
