Thread: If cell equals a text value return a value from corresponding cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Guerrier Nick Guerrier is offline
external usenet poster
  
Posts: 1
Default If cell equals a text value return a value from corresponding cell
A B C
1 Room Service Use
2 10100 PSYCHIATRY MUSIC RM

Basically I need a formula that wil take If B2 = "psychiatry", print(or
list) corresponding A cell, in this case 10100. I'd liek to be able to
print(list) all the rooms of the hospital under their corresponding service.
I can total, across floors, but I am having a bear getting what I what as
described.


--
Thanks, Nick
Reply With QuoteReply With Quote