EXCEL INVOICE TEMPLATE THAT UPDATES DATA AS I INPUT ITEM#

[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?

 

[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