Ask Your Question
0

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

=IFNA(INDEX($H$11:$H$42,MATCH(N36,$CK$11:$CK$42,0)),"")

example:

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
0

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.

=IFNA(INDEX($H$11:$H$42,IFNA(MATCH(N36,$CK$11:$CK$42,0),MATCH(N36,$CL$11:$CL$42,0))),"")

Edited to add missing close parenthesis.

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 1,333 times

Last updated: Aug 16 '16