Forum Discussion
How to reference to a cell but not with vlookup function or referencing by + sign
How about this?
Though make sure that the account number in A are texts. And in this example I limited the data ranges to only 20 rows. You can adjust that a much larger range, though avoid referencing entire columns like A:A.
Even better to use a structured table for the data. Such a table will expand automatically when you add rows to it and you can reference ranges by the table and column name.
How about this?
Though make sure that the account number in A are texts. And in this example I limited the data ranges to only 20 rows. You can adjust that a much larger range, though avoid referencing entire columns like A:A.
Even better to use a structured table for the data. Such a table will expand automatically when you add rows to it and you can reference ranges by the table and column name.