conditional comparison in a data range

[Mona]

Hello:

I have 2 worksheets. The first is a product price data
sheet and the second the clients product usage sheet.

My task is to get the price of the product from the pdt
price sheet by comparing the clients pdt-code with all the
codes in the second sheet. then displaying this price in
the client's worksheet.

How can this be achieved. I know that conditional
comparisons has to be made. but not sure exactly how.

Any help in this regard is much appreciated.
Thanks in advance.

 

[CLR]

Hi Mona.........

This sounds like a job for VLOOKUP to me. Assuming your product codes are
in column A of sheet 1, and the prices are in column B, then you can
highlight that area and do Insert > Name > Define, and give it the name
PriceList............... then in your Client Usage Sheet, you could use
something like

=VLOOKUP(A2,PriceList,2,false) assuming A2 contained the code you wanted to
look up..........the formula can then be copied down as needed.

Post back if you have trouble, or if this don't do it for you.........


Vaya con Dios,
Chuck, CABGx3