Hello Excel Collective
I am new to tables, I usually go Willy-Nilly and do not format my data to tables.
Usually that does work for me without any big problems.
Sadly my unwillingness to work and learn tables placed me into a situation which I feel quite difficult to find info on.
I am now working with a MS Forms and the data from that form comes formatted as a Table.
Simple stuff like referring to a value in cell in a table does not work and i get the #Value! error.
So if i write
Instead it shows
and in turn gives me the error #Value! in the cells (A1;A2;B1;B2)
For some reason though it does not do it always, I have some cells where it manages to extract and use the value from the cell in the table.
Right now I struggle with this:
=XLOOKUP(Table1[@[HeaderColumnA]];'Sheet1'!$A:$A;'Sheet1'!$B:$B)
This also only returns: #Value!
While I have another function that is identical and works:
=XLOOKUP(Table1[@[HeaderColumnA]];'Sheet1'!$A:$A;'Sheet1'!$C:$C)
I feel silly as it does not make sense.
I am new to tables, I usually go Willy-Nilly and do not format my data to tables.
Usually that does work for me without any big problems.
Sadly my unwillingness to work and learn tables placed me into a situation which I feel quite difficult to find info on.
I am now working with a MS Forms and the data from that form comes formatted as a Table.
Simple stuff like referring to a value in cell in a table does not work and i get the #Value! error.
So if i write
A | B | |
1 | =sheet2(a1) | =sheet2(b1) |
2 | =sheet2(a2) | =sheet2(b2) |
Instead it shows
A | B | |
1 | =Table1[@HeaderColumnA]] | =Table1[@HeaderColumnB.:]] |
2 | =Table1[@HeaderColumnA]] | =Table1[@HeaderColumnB.:]] |
and in turn gives me the error #Value! in the cells (A1;A2;B1;B2)
For some reason though it does not do it always, I have some cells where it manages to extract and use the value from the cell in the table.
Right now I struggle with this:
=XLOOKUP(Table1[@[HeaderColumnA]];'Sheet1'!$A:$A;'Sheet1'!$B:$B)
This also only returns: #Value!
While I have another function that is identical and works:
=XLOOKUP(Table1[@[HeaderColumnA]];'Sheet1'!$A:$A;'Sheet1'!$C:$C)
I feel silly as it does not make sense.