RookieExcel22
New Member
- Joined
- Aug 11, 2023
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hi,
I have the below table of data
I want to bring the data in column Question 1 into a table that looks like this
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.
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.