Hi,
I am looking for to change the below as VBA codes and make it dynamic :
I do not know where to start
=IFERROR(INDEX(PO_Detail!C:C,MATCH(1,(PO_Detail!A:A=VD_Backlog!A2)*(PO_Detail!B:B=VD_Backlog!B2),0))," ")
Please find attached a workbook with two tabs :
- VD_Backlog
_PO_Detail
The formula is within column C.
I'd like this formula to be generate through VBA and the cells will have only the "Value" found and not the formula
Many thanks for your help
I am looking for to change the below as VBA codes and make it dynamic :
I do not know where to start
=IFERROR(INDEX(PO_Detail!C:C,MATCH(1,(PO_Detail!A:A=VD_Backlog!A2)*(PO_Detail!B:B=VD_Backlog!B2),0))," ")
Please find attached a workbook with two tabs :
- VD_Backlog
_PO_Detail
The formula is within column C.
I'd like this formula to be generate through VBA and the cells will have only the "Value" found and not the formula
Many thanks for your help