I want to create a formula that matches the Intake Number in both sheets and then returns the Investigator Updates to the main sheet on the correct row.
Everything I am trying with Match and Index isn't giving me anything!
Hi!
Can you post screen captures of how you're setting up the Index(Match formula (what columns are you selecting)?
An INDEX(MATCH works like this:
=INDEX({Column with value to return}, MATCH([Value to match]@row, {Column with value to match in the other sheet}, 0))
In your instance, you'll need to make sure that 0 is there at the end of the MATCH function because it identifies that the values aren't sorted in the other sheet.
So, it would be something like this:
=INDEX({Investigator Updates Sheet 2}, MATCH([Intake Number]@row, {Intake Number Sheet 2}, 0))
Let me know if this is returning an error or an incorrect result!
Cheers,
Genevieve
