I want to do an advanced lookup and the Index Match function is not working for me. In the attached spreadsheet I have a tab labeled WorkRvu that list 10 physician, I wanted to look their Financial Class - HMO total on the next tab.
Ex - Physician 1 should return a value of 511.98 based on the information on the second tab. Does anyone have a formula that would pull this?
Thanks!
Last edited by day92; 01-20-2011 at 06:16 PM.
no attachment.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry about that. Its attached.
After correcting the spelling of Physician in Data sheet, column B, then try in B3:
=SUMIF(Data!D:D,A3&"HMO",Data!E:E)
copied down.
Bonus: Better formula for Data!D3: =CONCATENATE(LOOKUP(REPT("z",255),B$3:B3),C3) copied right down the column...
Last edited by NBVC; 01-20-2011 at 03:26 PM.
Easy enough! Why didnt I think of that.
Thanks!
Ok I ran into a bit of a snag, what happens when there are two HMO's? Take a look at the attached sheet.
What is supposed to happen? Right now it is summing all occurrences.
I must be having a bad day. Its working.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks