Forum Discussion
Solved
Stocksheet cells to update on invoice
Hi I have stock sheet with a list of products. There are only 26 on the test sheet. I would like to reference the cells in an invoice. The products have a name, stock code and price. I added ...
In the attached file there is a defined name "Product". This defined name refers to column A (column name is "Product") in sheet "Stock Sheet". In the screenshot the german "Bezieht sich auf" means "refers to".
This defined name is entered as source list for data validation.
=IFERROR(INDEX($H$2:$H$23,MATCH($A2,$G$2:$G$23,0)),"")You can try INDEX / MATCH as shown in the example.
=IFERROR(INDEX($I$2:$I$23,MATCH($A2,$G$2:$G$23,0)),"")This formula is in cell D2 and copied down.
