We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

index match (or) function [closed]

asked 2016-08-16 17:20:36 +0200

JG101 gravatar image

updated 2020-09-08 15:40:39 +0200

Alex Kemp gravatar image

would like to index column H match column N with Column CK or CL

=ifna(index(columnH,match(coumnN,columnCK or ColumnCL),0)),"")

How can I write where it looks at Column CK if no match it will look at Column CL, if there's a match it will show ColumnH value?

if tried using * between column function, also tried using &

i need to incorporate $CL$11:$CL$42 into this function



Row 10 column H = 100

column N = @CA

column CK = CA

column CL = @CA

side note:

I do not need both columns to Match, I only need one column to match (either or N36 will match CK column or CL column ) and come back with a value from Column H

thank you in advance for any help provided.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 17:04:28.276078

1 Answer

Sort by » oldest newest most voted

answered 2016-08-16 18:10:16 +0200

mark_t gravatar image

updated 2016-08-16 19:16:13 +0200

I think this should work but I have not tested as I don't have sample data.


Edited to add missing close parenthesis.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-16 17:20:36 +0200

Seen: 1,412 times

Last updated: Aug 16 '16