Automatically filling a cell from a worksheet based on a selection

P

Pbrent

I have an invoice form in which I would like to automatically insert the
price based on the item selection in another cell. My data is a small table,
2 columns one for item, one for price. On my invoice for, I am able to
select my item from a drop down box, now I would like to automatically fill
the price column based on the item selection. What formula or function do I
need to use.
 
R

Roger Govier

Hi

Assuming your pricing data are on Sheet2 in columns A and B.
Also assuming that your item selection is in column C, on sheet1
In cell D2
=IF(C2="","",VLOOKUP(C2,Sheet2!$A:$B,2,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Invoicing and customer database 0
Mail Merge Directory Conditional Page Break 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Generated text copies into another template 0
Drop down box w/contents of different worksheet? is this possible 1
Auto populate value from one task to another in MS PROJECT 0

Top