Forum Discussion
Match values from two different columns on two sheets (same workbook) and give result from a 3rd col
Hi, Will try to do this request in bullet point: Workbook will be adding a sheet each day with similar data Need to match certain data from previous day to current day Data will be taken off a...
=INDEX($F$3:$F$8,MATCH(1,(A12=$D$3:$D$8)*(E12=$A$3:$A$8),0))Maybe with INDEX and MATCH. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.