February, 2018 | Basic Excel Tutorial

How to Find text in a range and return cell reference

November 23, 2022February 11, 2018 by Admin

Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value in a range of cells. INDEX function can be used in two ways, INDEX reference and INDEX array The reference form returns the reference to

Nested If and Vlookup Function

November 28, 2022February 3, 2018 by Admin

If formula can be used together with VLookup formula to return an exact match of values and an empty string if the value is not found. The combination of these formulas makes excel tasks more effective. Example: Look for a commission using the Vlookup function Calculate Bonus by getting a product of total and commission.