Perform a left merge, this will use sku column as the column to join on: In [26]: df.merge(df1, on=’sku’, how=’left’) Out[26]: sku loc flag dept 0 122 61 True b 1 122 62 True b 2 122 63 False b 3 123 61 True b 4 123 62 False b 5 113 62 True a … Read more
If you only want to return a blank when B2 is blank you can use an additional IF function for that scenario specifically, i.e. =IF(B2=””,””,VLOOKUP(B2,Index!A1:B12,2,FALSE)) or to return a blank with any error from the VLOOKUP (e.g. including if B2 is populated but that value isn’t found by the VLOOKUP) you can use IFERROR function … Read more