Index, Match with AND formula

I am trying to create a index, match formula were I need to match 2 criteria's. is this possible? I tried the following with AND . This returns "INVALID DATA TYPE"

=INDEX([Column4]68:[Column4]72, MATCH(AND([Column2]68:[Column2]72, [Column8]68, [Column3]68:[Column3]72, [Column7]68), 0))

Find more posts tagged with

Formulas

Comments

Paul Newcome

Are you able to provide some screenshots or more detail as to your process? I may have a few ideas, but I want to make sure we get you the correct solution.

Sign in to join the conversation!

Quick Links

Trending discussions

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…