Microsoft Office Forums formula to grab information on different sheet, only if meeting certain criteria

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2016, 10:05 PM
bex_77 bex_77 is offline formula to grab information on different sheet, only if meeting certain criteria Windows 7 32bit formula to grab information on different sheet, only if meeting certain criteria Office 2010 32bit
Novice
formula to grab information on different sheet, only if meeting certain criteria
 
Join Date: Oct 2016
Posts: 2
bex_77 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 10-19-2016, 03:30 AM
xor xor is offline formula to grab information on different sheet, only if meeting certain criteria Windows 10 formula to grab information on different sheet, only if meeting certain criteria Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe like the attached?
Please note that I have created two names, d and region. See Name Manager.
Attached Files
File Type: xlsx bex_77.xlsx (288.0 KB, 3 views)
Reply With Quote
  #3  
Old 10-19-2016, 03:42 AM
bex_77 bex_77 is offline formula to grab information on different sheet, only if meeting certain criteria Windows 7 32bit formula to grab information on different sheet, only if meeting certain criteria Office 2010 32bit
Novice
formula to grab information on different sheet, only if meeting certain criteria
 
Join Date: Oct 2016
Posts: 2
bex_77 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Maybe like the attached?
Please note that I have created two names, d and region. See Name Manager.
That's great! Thank you xor 😊
Reply With Quote
Reply

Thread Tools
Display Modes


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
formula to grab information on different sheet, only if meeting certain criteria 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 to grab information on different sheet, only if meeting certain criteria 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


All times are GMT -7. The time now is 01:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft