[SOLVED]=IF(Names!B4:B25="BR42","No","Yes")
When I used this formula it seems to only evaluate the first cell. What I'm trying to do is if BR42 is in any of the cells B4:B25 on the Names Sheet then it would come back No. What am I doing wrong. I fairly new with Excel.
Thanks
Last edited by deananne; 08-06-2011 at 05:14 PM.
=IF(countif(Names!B4:B25,BR42),"No","Yes")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Another common method:
=IF(ISNUMBER(MATCH(BR42, Names!$B$4:$B$25, 0)), "No", "Yes")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Neither of these seem to be doing what i need. Probably because I'm not explaning corrrectly. I have a worksheet that has names on it and each name has been asigned a room number like BR42. On the other worksheet i have listed all the rooms down and want to be able to say if they are available or not.
post the work book
Here's the file. Notice That the room BR42 is assigned and shows on the Brick Row sheet is not available (No). But if you change the room to BR43 or something else on the Names sheet it should change the Brick Row sheet to showing available (yes), because it hasn't been used.
Thanks for your help.
The formula I gave works fine once you put in the correct match value... put this in C5 and copy down:
=IF(ISNUMBER(MATCH(B5, Names!$B$4:$B$25, 0)), "No", "Yes")
same for me see what happens without a workbook we assumed BR42 was a cell reference not a value
Thats what I was looking for.
Thanks :)
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks