Discussion Re: need help with a formula in Excel
https://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414250#M63397
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.<BR /><BR />Hopefully it works for you.Sun, 24 May 2020 02:39:29 GMTJMB172020-05-24T02:39:29Zneed help with a formula
https://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414205#M63391
<P>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 a Case Weight and a certain number of expected visits per month. I would like to be able to enter the Service Level and have the corresponding Case Weight and Expected Visits columns to autopopulate in the appropriate cells. If anyone can help with this, I'd be very grateful. I've watched a ton of videos and tried the forumlas suggested, but the closest I came to having it work got me a #SPILL error.</P><P> </P><P>Thank you for this network!</P><P>Alyson</P>Sun, 24 May 2020 01:11:53 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414205#M63391alyson19402020-05-24T01:11:53ZRe: need help with a formula
https://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414219#M63393
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).<BR /><BR />Cell S4: =VLOOKUP(Q4,$Q$7:$T$50,3,FALSE)<BR />Cell T4: =VLOOKUP(Q4,$Q$7:$T$50,4,FALSE)<BR /><BR />Change $Q$7:$T$50 to the actual range address of your table.<BR />Sun, 24 May 2020 01:40:58 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414219#M63393JMB172020-05-24T01:40:58ZRe: need help with a formula
https://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414231#M63396
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.Sun, 24 May 2020 02:01:22 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414231#M63396alyson19402020-05-24T02:01:22ZRe: need help with a formula
https://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414250#M63397
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.<BR /><BR />Hopefully it works for you.Sun, 24 May 2020 02:39:29 GMThttps://techcommunity.microsoft.com/t5/excel/need-help-with-a-formula/m-p/1414250#M63397JMB172020-05-24T02:39:29Z