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...
I'm assuming you want to lookup the level in Q4 and return the case weight and expected visits, which are in the table starting at Q7 (not sure how far down it goes).
Cell S4: =VLOOKUP(Q4,$Q$7:$T$50,3,FALSE)
Cell T4: =VLOOKUP(Q4,$Q$7:$T$50,4,FALSE)
Change $Q$7:$T$50 to the actual range address of your table.
Cell S4: =VLOOKUP(Q4,$Q$7:$T$50,3,FALSE)
Cell T4: =VLOOKUP(Q4,$Q$7:$T$50,4,FALSE)
Change $Q$7:$T$50 to the actual range address of your table.
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.