In this case and any time we're trying to match up text entries, we need to use VLOOKUP in a different way. Now, in an earlier movie, you may have seen how to do an approximate VLOOKUP. On this worksheet called ExactVLOOKUP, we'd like to convert these ratings in column A into numerical scores based on the Rate Table that we see over in columns A and B.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |