xlookup against multiple columns in lookup array

[RookieExcel22]

Hi,

I have the below table of data

Column G	Col H	Col I	Col J
Value	Value	Question 1	Question 2
AB	AD	3	2
AC		4	5

I want to bring the data in column Question 1 into a table that looks like this

Col A	Col B
Value	Question 1
AB	3
AC	4
AD	3

I know I can use an ifna(vlookup but that is a lot of effort. I tried an xlookup hoping it could look against both value columns but that did not work. I ended up using this formula:

=IFNA(XLOOKUP(A2,$G$2:$G$3,XLOOKUP(B$1,$I$1:$J$1,$I$2:$J$3)),XLOOKUP(A2,$H$2:$H$3,XLOOKUP(B$1,$I$1:$J$1,$I$2:$J$3)))

While it did work, it is a bit of effort to set up as I have 15 value columns. Wondering if there is a simpler way! Thank you.

 

[RookieExcel22]

It works for me with more than 255 characters. Can you post the actual data.

Strange, I will continue to play with it. There were some special characters too, not sure if that causes issue. Unfortunately, I cannot share the data .

 

[Fluff]

Ok,