From Rahim’s Post:
The Excel lookup function (LOOKUP, VLOOKUP and HLOOKUP) are not case sensitive. For example, if you write a lookup function to look up the text rahim, the function considers any of the following a match: RAHIM, Rahim or RaHiM
1. Create the sheet given below:
The figure below shows a simple example. Range D2:D7 is named Range1, and range E2:E7 is named Range2. The word to be looked up appears in cell B1 (named Value). … To Read More Click Here to go to Rahim Zulfiqar Ali’s Lesson.
You may find Rahim Zulfiqar Ali Google Sites