=If(VLOOKUP(B2,'HDM- Charts Coded Not Released '!$E:$E,1,FALSE),"HIM",(vlookup(B2,'HDM- Charts Coded Released'!$D:$D,1,false),"HIM",(vlookup('KG REASON for Hold Outpat'!$F:$F,1,false),"HIM",(vlookup('OBER Data'!S2,Assumptions!$B:$E,4,false)
The logic is:
If vlookup1 = yes than HIM
If N/A than vlookup2 = yes than HIM
If N/A than vlookup3 = yes than HIM
If N/A than vlookup4
Last edited by rwmeis; 08-20-2013 at 05:09 PM.
Try
=IF(AA6="Series","Wound Care",IFERROR(VLOOKUP(S6,Assumptions!$B:$E,4,FALSE),"HIM"))
rwmeis,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Is that descriptive enough?
Your formula above worked unfortunately my logic was off sequentially. Thank you for the help though!
=If(VLOOKUP(B2,'HDM- Charts Coded Not Released '!$E:$E,1,FALSE),"HIM",(vlookup(B2,'HDM- Charts Coded Released'!$D:$D,1,false),"HIM",(vlookup('KG REASON for Hold Outpat'!$F:$F,1,false),"HIM",(vlookup('OBER Data'!S2,Assumptions!$B:$E,4,false)
The logic is:
If vlookup1 = yes than HIM
If N/A than vlookup2 = yes than HIM
If N/A than vlookup3 = yes than HIM
If N/A than vlookup4
Perhaps Vlookup isn't even the best tool for your task.
You're using 1 as the column Index, indicating you're really just verifying the existance of B2 in one of the sheets..
Try
=IF(COUNTIF('HDM- Charts Coded Not Released '!$E:$E,B2),"HIM",IF(COUNTIF('HDM- Charts Coded Released'!$D:$D,B2),"HIM",IF(COUNTIF('KG REASON for Hold Outpat'!$F:$F,B2),"HIM",vlookup('OBER Data'!S2,Assumptions!$B:$E,4,false))))
The advantage here is that Countif doesn't error if the value isn't found.
Thanks everyone for the help. This site is awesome!
Don't you have another thread going on the same thing?
http://www.excelforum.com/excel-form...mula-asap.html
completely different logic. I have learned iferror aspect. I am confused about how to make it return the value "HIM", if the vlookup is yes.
Last edited by rwmeis; 08-20-2013 at 05:05 PM.
If you don't have anything to contribute why even bother to waste your time?Originally Posted by Jonmo1
I did contribute, thank you .
My bad...Thanks....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks