INDIRECT Excel Function Formula, Examples, How to Use It?
The function returns the value(s) present in the stored reference. Working with the INDIRECT function can be tricky because you can't actually see the reference it returns. In the worksheet below, VLOOKUP is used to get costs for two vendors, A and B. The INDIRECT function then evaluates the text and converts it to a valid reference. The INDIRECT function is like a magic wand that converts a text value to an actual reference. Follow the below steps to use...
