Ask Your Question
0

index match (or) function

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

JG101 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,091 times

Last updated: Aug 16 '16