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 ...
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.