Home > Forum Home > Building Market Trading Systems > How to place a known value in an already complete table. > Use a reference and ADDRESS function | Share |
Forum Topic | Login |
Use A Reference And Address Function | Rate this: (3/5 from 1 vote) |
You can use the combination of a reference function (such as MATCH) along with the ADDRESS function to locate a cell based on its value. From there you can populate the blank cell with the desired value. For an example of this, see this post. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Use a reference and ADDRESS function in the Excel Business Solutions Directory |