|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula to grab information on different sheet, only if meeting certain criteria
Hi,
I am hoping you can help me. I have created an IF formula to grab the information I require, however when the criteria is not met, it fills the box with FALSE. Instead, I would like it to skip and move onto next cell. Ideally I do not want spaces between my list. I have attached a copy of the sheet. On the PaRR tab, I would like cell A2 to display the school name from the Services tab, but only if it is in the specified region. As you can see I have spaces in between my results. Is it possible to remove these? Thank you. Last edited by bex_77; 10-19-2016 at 02:07 PM. Reason: SOLVED - removed attachment |
#2
|
|||
|
|||
Maybe like the attached?
Please note that I have created two names, d and region. See Name Manager. |
#3
|
|||
|
|||
That's great! Thank you xor 😊
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
Setting autofilter criteria using columns and cells relative to the active cell in another sheet | SarahL | Excel Programming | 7 | 06-11-2015 10:26 AM |
Create an attendance sheet for monthly club meeting | jcc285 | Word VBA | 0 | 08-30-2014 09:34 AM |
Formula with 3 Criteria | bremen22 | Excel | 3 | 09-24-2013 11:39 AM |
Pull Outlook Meeting Information into Word | alhare | Word | 0 | 02-01-2011 12:51 PM |