Forum Discussion
need help with a formula
Hello everyone. I'm a social worker trying to lighten my load of complex computations when doing quality control activities. Our clients are assigned one of multiple service levels which determines...
You assume correctly. That's a new formula for me so I'll give it a try. Thank you. I'll get pack to this post after I try it to let you know.
VLookup performs a vertical lookup. It matches a given value (Q4) to the leftmost column of a table (Q7:T50) and then returns a value from the nth column (3 and 4 respectively). The last argument, FALSE, tells it to exactly match the item it is looking up, versus an approximate match.
Hopefully it works for you.
Hopefully it works for you.