Fetching Value based on Multiple columns

[kseenu]

Hi,

I need to fetch the values in the Sheet based on multiple columns.

I need to get the Qty & Amt values from "Detail" sheet based on the column Part and Months and display it in the "Master" Sheet.

The values may be not be available for some months.

Can we perform this using any Lookup functions / thru macro.

Attaching a sample sheet.

Thanking you in advance


--Seenu

[bonny24tycoon]

I'm not able to understand, if the Details tab and Master tab are so indentical, why isnt the data directly inputted on the master sheet???

[kseenu]

The Details is extracted from a different Data source.. It will be received as a seperate Page.

I will be refering the values in the Master File along with other calculations.

[kseenu]

Hi,

Any Helps or Pointer in resolving this issue?

thanks
Seenu