Return a value from another sheet based on two criteria

Fanny

hi all,

I have two sheets that contains a lot of identical values. I want to report in sheet 1, a value from sheet 2 named "

OR_Dashboard_Automation

" based on two criteria that should be met : the week number and the rowID. The value to be reported is the one in the "range 3"

I have tried an IF formula that was like this :

=IF(AND([Week number]@row = {OR_Dashboard_Automation Week Number}, [Row ID]@row = {OR_Dashboard_Automation rowID}), {24MAR2025_OR_Dashboard_Week13 Range 3}, "")

It's not working. I also tried with CONTAINS but was not working either

Thanks in advance for your help

Jgorsich

Formulas are very literal. What you've typed there, translated to plain english, is the following:

if the week number in this row is the same as THE ENTIRE RANGE OF {OR_Dashboard_Automation Week Number} and the row ID in this row is the same as THE ENTIRE RANGE OF {OR_Dashboard_Automation rowID} then return THE ENTIRE RANGE OF {24MAR2025_OR_Dashboard_Week13 Range 3}.

That will never return the value you are looking for.

Look into the Index(Match()) formula combination (where you index through a range until you match a value) or the Index(Collect()) formula combination (where you collect all qualifying data then index through THAT some predefined amount of times).