Forum Discussion
xlookup with table issue
Hello! I am working on a file that requires use of xlookup. to keep things organized and for ease of reviewal, i use the table headers in the formulas (instead of just column letter). I realized ...
XLOOKUP returns first found value.
Could you please share the sample or at least screenshot of what exactly you'd like to do?
SergeiBaklan Thank you for your response. I do know that about xlookup. I am saying that the next xlookup that is looking up a different value, doesn't work.
For example below:
- in the lookup array: the first row of data is the row with "A", the second row of data is the row with "B"
- example formulas and output:
- xlookup("A",[lookup array], [return array]) --> output = A
- xlookup("B",[lookup array], [return array]) --> output = error
after deleting the "A" from the lookup array
- xlookup("A",[lookup array], [return array]) --> output = error (understandably)
- xlookup("B",[lookup array], [return array]) --> output = B
Does this make sense?
- Also, when i use xlookup with the column letters (as opposed to in the table header format), it works perfectly; all values are returned correctly.
- please post an example of the actual formula you are using. is it possible your are using the "table header" format incorrectly? for example it sounds like you have @[columnHeader] which would return only that line instead of the whole column, but maybe it is something else. hard to say without additional information.
