in column i i want to bring projects from sheet 5 based on column A AND C from sheet 4 and A/B/D sheet 5 .
exc.xlsx
in column i i want to bring projects from sheet 5 based on column A AND C from sheet 4 and A/B/D sheet 5 .
exc.xlsx
Alex
I2=MATCH(YEAR(A2)&MONTH(A2)&C2,Sheet5!$A$3:$A$6&Sheet5!$B$3:$B$6&Sheet5!$D$3:$D$6,0), copy down.
=INDEX(Sheet5!$H$3:$H$6,MATCH(YEAR(A2)&MONTH(A2)&C2,Sheet5!$A$3:$A$6&Sheet5!$B$3:$B$6&Sheet5!$D$3:$D$6,0)) the correct one is this, but you remind me about the rest thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks