Say you want to assign a value to a data item with a VLookUp. The data item is a number that will be in a range, like a score of 87 on a test earning a B where the range was from 81-90.
Use a VLookUp without a Range-Lookup value. First create your lookup table with the lowest end of the range for each one, so if 61-70 was a D, 71-80 a C, 81-90 a B and 91+ an A, column 1 of your table would be 0, 61, 71, 81, 91, with the next column, F, D, C, B, A, respectively. If your grade were in D1 and your table in A1:B5, your VLookUp would read =VLookUp(D1,$A$1:$B$5,2).
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/35965/want-to-assign-a-value-to-a-data-item-with-a-vlookup "