Well, you could search something that was close to what you were looking for, or you could get another book. A VLookUp is structured the same way: what, where, which, and what if. Only, VLookUp calls it Lookup_Value, Table_array, Col_index_num and Range_lookup.
To see how it works, create this two column list in a blank worksheet.
A B
1 Red
2 Green
3 Blue
4 Orange
5 Yellow
6 Brown
7 Black
8 Purple
Then, in cell D1, type a 3. In E1, type: =VLookUp(D1,$A$1:$B$8,2,0).
This will “look up” the color number in the list and return the color name in text. If you typed in the colors above in that order it should have returned Blue. Translated it works like this:
To learn more from Melissa, view one of her 'Learn it On-Demand!' Webinars.
Welcome to the ASAP Circle, a community platform for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We even have designated spaces for weekly Tuesday Coffee Breaks.