Ajit

If you put this IF formula into your worksheet "Bill"
=IF(Muster!B3="P",Pricelist!B3,IF(Muster!B3="A",0, "CHECK MUSTER"))

I have assumed for this that the first P for John on Sun 1st in your example
is in cell B3, and similarly that the Price for Times on Sun 1st is also in
B3 - this also assumes that John always takes the Times so uses the same row
all of the time?

I have given you a nested IF to add to this - this last part is for if
neither "P" nor "A" has been entered and to give you a warning rather than
just assume it can be blank or zero...

Steve





"Ajit Munj" wrote:

I have workbook named News.xls with 3 sheets namely Pricelist, Muster and
Bill for the month of January, 2005.
Muster contains presenty of each client, marked P for present & A for Absent
A.....B.....C.....D.....
Days Sun Mon Tue Wed
Date 1 2 3 4
1 John P A A P
2 Lucy A P P A
3

Pricelist contains prices for news papers (amount in Indian Rupees)
A.....B.....C.....D.......E.........F.......G..... ..H...
Days Sun Mon Tue Wed Thu Fri Sat

Times 5 4 4 4 4 4 3.50

Economic 9 2 2 2 2 2 9

Now I want to prepare bills in sheet "Bill". I want Excel to check first
from Muster whether client is marked as "P" on 1st of Jan, 05 (Saturday), if
so, he should take a price of Times newspaper for Saturday from sheet
Pricelist i.e. Rs.5/-, if not, put 0.00, & so on.. Thus my sheet will show :


A.....B.....C.....D.....E.......F......G.......H.. ....I..Total
Days Sat Sun Mon Tue Wed Thu Fri Sat
Date 1 2 3 4

1 John 4 5 4 4 4 0 0 4 25.oo



Note : On Thu & Fri John was marked as "A"
How can I perform this in sheet Bill.


--
Knowldege is Power