Linking data on different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a worksheet with item codes and prices and a worksheet with a
invoice/quotation. By typing in the item code on the invoice, I would like
exel to put in the price automaticaly.

Can this be done, and if so, how do I go about to get this done?
 
See VLOOKUP function

=VLOOKUP("itemcode",Sheet1!A:B,2,0)

where columns A & B of sheet1 contains item codes and prices

"itemcode" is cell with item code
 
You must log in or register to reply here.

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

Pick Price From Contract Info 4
template creates invoice - how to create summary worksheet? 13
Cumulatively list data from each new worksheet 1
VBAscript for data matching excels 0
tracking inventory 5
Create an Invoice from a row of data 2
HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top