Auto populate a cell with a price

		Microsoft Office Forums > Microsoft Excel > Excel
Auto populate a cell with a price

FAQ

Thread Tools

Display Modes

10-24-2021, 03:36 PM

Marcia

Windows 10 Auto populate a cell with a price

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

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)),””)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate cell with today's date	Phil H	Excel Programming	7	10-18-2017 09:41 AM
Auto populate cell based on certain situations	YW3	Excel	10	05-26-2017 02:02 AM
auto cell populate 2	Stevejd58	Excel	3	08-20-2013 04:23 PM
auto cell populate	Stevejd58	Excel	14	05-13-2013 02:22 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 PM.