Prev: Find a number in a column then return a value from another cell
Next: long printing on a plotter
From: Pbrent on 14 May 2010 10:00
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.
From: Gary''s Student on 14 May 2010 10:31
Use VLOOKUP()
--
Gary''s Student - gsnu201003


"Pbrent" wrote:

> 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.
From: Roger Govier on 14 May 2010 10:39
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))
--
Regards
Roger Govier

Pbrent wrote:
> 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.
 | 
Pages: 1
Prev: Find a number in a column then return a value from another cell
Next: long printing on a plotter