Hello,
I'm trying to create a formula that compared two criteria and returns all results horizontally. I've got the searching against multiple criteria part, however I'm having trouble returning all matched results horizontally if multiple results are found. Below is my spreadsheet:
And here is the formula I've created to search against multiple criteria.
It's comparing values in columns I and J against values in columns A and C and returning the corresponding value in the same row, in column B.
Any help with this would be appreciated!
I'm trying to create a formula that compared two criteria and returns all results horizontally. I've got the searching against multiple criteria part, however I'm having trouble returning all matched results horizontally if multiple results are found. Below is my spreadsheet:
And here is the formula I've created to search against multiple criteria.
Rich (BB code):
=INDEX($B$1:$B$3398,MATCH(1,(I2=$A$1:$A$3398)*(J2=$C$1:$C$3398),0))
It's comparing values in columns I and J against values in columns A and C and returning the corresponding value in the same row, in column B.
Any help with this would be appreciated!