XLOOKUP to return cell based on multiple criteria in single column

**mikehay08** · 05-21-2021, 02:35 PM

I feel like I am right on the cusp of getting this done, but I am missing something. I can do an Index/Match formula that find x in Column A, y in Row 1, and then return the intersecting cell. My issue is, I have multiple criteria that needs met in Column A. So it needs to match criteria x in Colum A, criteria xx in Column A, then y in Row 1. Criteria x is a category, criteria xx is a subcategory that repeats itself in multiple x categories. Please see the basic attachment here.

Example of what I want is in the "solutions" tab. I'd like a formula that just references the Column A criteria x, Column A criteria xx, then Row 1 criteria y.

**Limor_OP** · 05-22-2021, 04:22 PM

Hello,
Please see 'Output' tab

use this in B3 and across:
=INDEX(CHOOSE(RIGHT($A3,1),Input!$B$3:$D$6,Input!$B$9:$D$12,Input!$B$15:$D$18),MATCH(INDEX($A$1:$A2,MATCH(2,1/($A$1:$A2=""))+1),CHOOSE(RIGHT($A3,1),Input!$A$3:$A$6,Input!$A$9:$A$12,Input!$A$15:$A$18),0),MATCH(B$1,$B$1:$D$1,0))

**Gregb11** · 05-22-2021, 09:48 PM

Isn't this a duplicate post of this?

**mikehay08** · 05-24-2021, 10:50 AM

@gregb11 Yes it is. When I initially posted, nothing showed up for about 15 minutes. So I created a new post, creating the duplicate. Trying to figure out how to delete so I am not taking up more space than necessary

**Limor_OP** · 05-24-2021, 02:59 PM

so at least mark this as resolved.

XLOOKUP to return cell based on multiple criteria in single column

LinkBack

Thread Tools

Rate This Thread

Display

XLOOKUP to return cell based on multiple criteria in single column

Re: XLOOKUP to return cell based on multiple criteria in single column

Re: XLOOKUP to return cell based on multiple criteria in single column

Re: XLOOKUP to return cell based on multiple criteria in single column

Re: XLOOKUP to return cell based on multiple criteria in single column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Filter multiple sheets based on 3 criteria and return results into single cell

[SOLVED] Lookup - find multiple occurrences in column of single criteria; return value from other c

How to return multiple values (columns and rows) based on single criteria

[SOLVED] Return single value by searching multiple criteria in multiple column

return single value based on multiple criteria

[SOLVED] How to return multiple values to a single cell based on multiple criteria

Return Single Value Based on Multiple Criteria

Bookmarks

Bookmarks

Posting Permissions