EXCEL INVOICE TEMPLATE THAT UPDATES DATA AS I INPUT ITEM#


Z

zamberwe

i need to input data into an invoice template. when i put in item number i
want it to call item info and price from a list of inventory items so i can
print the invoice for a customer?
 
Ad

Advertisements

J

Jacob Skaria

Check out help on VLOOKUP(). VLOOKUP stands for vertical lookup and search
for a value in the first column of a table array and returns a value in the
same row from another column in the table array. Try the below formulas with
a similar data and try changing the name in Cell C1

ColA ColB ColC ColD ColE ColF
Name Age Sex Adam =formula1 =formula2
Adam 32 M
Marie 24 F
Francis 33 M
Joel 34 M
Susan 26 F
- - -
- - -
- - -
- - -


in place of formula1
=VLOOKUP($D$1,$A$1:$C$10,2,FALSE)

in place of formula2
=VLOOKUP($D$1,$A$1:$C$10,3,FALSE)

If this post helps click Yes
 

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

Top