Mar 31 2022 06:08 AM
I have several different excel files I use at work during my day.
One one I successfully used an INDEX and MATCH formula to pull information from my table into my cell.
However I would like to duplicate this in another file, however in my other file I have three tables I would like the information to be pulled from into one cell. Is something like this possible? If it makes a difference, the cell would be located on sheet 1 and the three tables would be located on sheet 2.
Mar 31 2022 06:26 AM
Please provide more detailed information.
Mar 31 2022 06:44 AM
Maybe like in the attached file?
Mar 31 2022 08:48 AM
Mar 31 2022 09:07 AM - edited Mar 31 2022 09:08 AM
I think you can use the Reference arrangement of INDEX. It's a bit different in syntax. Here's what one looks like:
=INDEX((Data!A1:A3,Data!C6:C8,Data!D1:D3),1,1,2)
The bolded part being your 3 ranges. You will receive a #VALUE! error if the tables used are not all on the same sheet.