I am clearly not using this right because I'm not getting the correct results at all. As I thought the function worked, Lookup([subject value],[range to match],[output of matching value]), B9 should output the value from the range that matches or is less than B8 (my subject). However my results are a mess. Anything <69= N/A, 69=C, and >69=F. Clearly I'm not doing this right. Please help.
Thanks,
Last edited by Punxatawny; 02-04-2019 at 03:25 AM.
Try changing your list to smallest to greatest, then use
=VLOOKUP(A8,$A$1:$B$5,2,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I see, the range must be smallest to biggest to work. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks