Good Day Everyone,
I was hoping you can help me with my problem. I can't somehow pull the Unit Price of an item using the data provided on a different table.
On the attached, my formula goes as follows:
=INDEX(TABLE5[Net price],MATCH([Item Code],TABLE5[Material],0))
Your help is very much appreciated.
Bookmarks