Hi

Amend the formula to
=IF(A2="","",VLOOKUP(A2,INDIRECT(B2),2,0)*(1-(50%*--(B2<"Silver"))))

If the entry is not from the Silver sheet, it will take 50% of the value
found on the other sheets.

--
Regards

Roger Govier


"Rao Ratan Singh" wrote in
message ...
Thankyou Sir,
Thank you very much. It is unbelieavalbe but true. It is working.

But one thing more . In Painting and Textile sheet I have doubled the
cost
price but in daily report i want to determine its actual what is 1/2
of value
entered in sheets.

The how i should entered formula.

Regards

Rao Ratan Singh
"Roger Govier" wrote:

Hi

If that is the case, then supposing that on sheet Textile, you have
your
ID's in column A and their Cost in column B.
Set up a defined name called Textile, with a range of say $A1:$B1000
or
sufficient to cover your product list.
Create names also for Silver and Painting

Then on your Daily Report sheet in cell C2
=IF(A2="","",VLOOKUP(A2,INDIRECT(B2),2,0))


--
Regards

Roger Govier


"Rao Ratan Singh" wrote in
message ...
Dear Roger,
Thank you for reply. But problem is value can be determine after
matching to
criteria. First ID No. which all are starting from 001 but its
range
name is
different that is Pntng_ID, Jwlry_ID and Txtl_ID. After that its
second
criteria should match that is it from sheet Painting or Silver or
Textile.

and one onother i dont want to + of determined value. It will
seperately
entered in next row.

My Daily Report Format is -
IDNo. Sheet Name Cost Price
0001 Textile =Formula (What is expected from you)
0002 Silver
0002 Painting
0003 Painting
0004 Silver
0006

Because after ID No. and Sheet Name is two criteria if found
matching
then
it should return proper cost value from respective cell.

Regards

RRS