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