Help with Index Match across Multiple Sheets

Angela Bearden

I need help with writing an Index / Match formula across multiple sheets. In my Remote RES sheet am trying to return the CNS No from the Engineering RES Database - SSTX sheet by Matching the SO # field. Screen shots of both sheets below.

David Joyeuse

Hi @Angela Bearden

That formula would be:

=INDEX({Engineering RES Database - SSTX - CNS NO}, MATCH([SO #]@row, {Engineering RES Database - SSTX - SO #}, 0))

Hope it helped!

Angela Bearden

I am getting #INVALID REF. I have verified that both sheets have the required information in them.

Paul Newcome

How are you creating your cross-sheet references? You should be clicking on the link in the "helper box" below where you are typing that says "Reference another sheet".