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.