View Single Post
 
Old 10-24-2021, 03:36 PM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Or, recreate a new table. Type the headings. Click mouse in the celle below product>>Open the Data tab>>Open Data Validation in the Data Tools group>>Open the dropdown of the Allow: box, select List>>in the Source: box type =Product>>OK
Under price, enter the code
=IFERROR(Index(Price,Match(B3,Product,0)),””)
Reply With Quote