I have a file with two spreadsheets. In spreadsheet2 Cell D5, I am trying to pull in the info from spreadsheet1’s column G when it matches with a search criteria on the same row that could be in anyone of spreadsheet 1’s column A:C.
In short I’m trying to match a value that could be found in multiple columns then pull in the value that is found on that same row in column 7. I’ve had some success but only if my match is found in the first column or I only search one column.
Sorry I am unable to post the spreadsheet. 1st time user. Any help is much appreciated.
This is an array formula, known as a CSE, or a CONTROL+SHIFT+ENTER formula. Don't confirm with just ENTER. When you confirm the formula entry, ensure it's the only cell selected. Here is a good explanation of the formula: