Hello,
I would like to combine the returned values of the following VLOOKUP’s into the same cell
=VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3)
and
=VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,4)
the last number is the only difference 3 and then 4
Can somebody here help me with this?
They will probably end up being more like this but the simpler version is easier to understand for me.
=IF(VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3)="","",VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3))
Many thanks,
Nick
I would like to combine the returned values of the following VLOOKUP’s into the same cell
=VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3)
and
=VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,4)
the last number is the only difference 3 and then 4
Can somebody here help me with this?
They will probably end up being more like this but the simpler version is easier to understand for me.
=IF(VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3)="","",VLOOKUP(VLOOKUP($F$8,Order_Data!$A$2:Order_Data!$N$8,2),Supplier_Data!$A$2:Supplier_Data!$L$100,3))
Many thanks,
Nick