Forum Discussion
Solved
Help on XLOOKUP array ranges
Hi - I have my customer master list with account numbers in one sheet in my workbook, and then I have each month as another tab. I capture my monthly sales in the month tab. I want to type in the c...
jackiebiggs Use table column instead of cell reference. Try-
=XLOOKUP([@[Customer Name]],CustomerList[Customer Name],CustomerList[Customer ID])
jackiebiggs Use table column instead of cell reference. Try-
=XLOOKUP([@[Customer Name]],CustomerList[Customer Name],CustomerList[Customer ID])
- Wonderful! How did you create this formula? I'm not sure what a table column is. Thanks!
