Prices

[tofimoon4]

Dear sir,with my regards, i need your help for this request :
i have a workbook with columns (agent,inv.no.,code,price) and a table contains (4) prices for (4)agents for about (500) codes .
how can i get the price of each (code ,agent)mentioned in invoices .
I am using excel 2003.
Thanks in advance.

[DonkeyOte]

Perhaps:

Please Login or Register  to view this content.

[tofimoon4]

Many thanks my dear for your help

[tofimoon4]

Dear sir,with my apology,i need your help about the above formula you have gifted : how can i reject (#N/A) which appears when i drag the formula down in my workbook , ineed this dragging because i am hiding it from seeing by others.
Thanks in advance.

[DonkeyOte]

The question is why are you getting #N/A -- is it because the criteria fields are blank ? If so then:

Please Login or Register  to view this content.

If it's because you are getting genuine errors - ie criteria values not found then you could adopt an approach such as:

Please Login or Register  to view this content.

[tofimoon4]

Thank you my sir , it worked very well.