I am using the index formula =INDEX(VendorPO1[#All],ROWS(K$6:K7),MATCH('Field Worksheets'!$K$5,VendorPO1[#Headers],0)) to populate a range of cells and it works perfectly. However, I would like to change the VendorPO# dynamically (ex. 1,2,3) by cell reference and am struggling. Any suggestions?
Bookmarks