Match Date and return corresponding data.

[SUJU]

Hi All,

I am trying to match the EXACT date from one sheet to another, and if true, then return the corresponding value next to the date, and if false return a blank cell. Matching Data.xlsx

Please no Macros, Pivot Tables, or VBA. I am not confident with these yet.

Please refer to spreadsheet for an example and explanation.


thanking you
best regards
SUJU

[jmaness]

HI,

Copy into cell sheet2!B2, fill down.

=IF(ISNA(INDEX(Sheet1!$B$1:$D$162,MATCH(Sheet2!A2,Sheet1!$D$1:$D$162,0),1)), " ", INDEX(Sheet1!$B$1:$D$162,MATCH(Sheet2!A2,Sheet1!$D$1:$D$162,0),1))

Select area sheet1 B1:D162, on the formulas tab select name manager and name this range. Do the same for range sheet1 D1:D162. Once you have named these ranges replace them in the above fomula with the names you just assigned.
After doing this you will be able to add new data by using the insert row function and the named range will automaticaly update to include the row in the range and will not have to wory about the formula breaking down as your data grows.

[SUJU]

Hi jmaness

thanks for your help. The solution worked out perfectly.

best regards
SUJU