Hi to all experts :
I want o define a formula in the cell H11 with the help of Index with Match or by another way in order to pull the exact data as per my need from the different sheet.
Here in the Sheet Dates i want if Air Duct in the cell D11 & F7 matches than from the Data_Sheet pull the date for example 02-Aug-2015 & if the cell empty so show is empty.
Furthermore, I want to use same strategy for other buildings such as 4302B 4304A & 4304B accordingly.
i tried to defined though several ways but couldn't succeeded.
waiting for your valuable feedback.
thanks....
Ecnls : Example Sheet
Bookmarks