ASAP Awards | The American Society of Administrative Professionals Submissions are open ›
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.
Join the ASAP Circle, a community platform that offers an opportunity for peer-to-peer conversation on trending topics, professional challenges, and shared experiences. We also offer a moderated coffee break each week on a rotating schedule where admins can speak and connect via Zoom. See you there!