Dear Max,
You have solved my many problem in this forum. Now I have problem.

I have three work sheets Named "paintings", "Silver", and "Textiles". These
are Invetory record. It have Column like-

ID No. Name of Item Pur_Cost

Every sheet's ID No. Start from 001

I submit daily report to my boss that particular item sold and its purchase
cost was this and sale value is this and gross profit/loss is this.

My Daily Sales report's format is -

A B C
ID No. Name of Item Cost_price Sale_price
001 Paintings =Formula()
001 Textiles
001 Silver
002 Textiles
003 Silver
003 Paintings

I want to use a formula in Column C that could determine cost value from
related worksheet after matching ID No. and Name of sheet

Hope u only can help me.

Regards

RRS