View Single Post
Old 10-18-2016, 10:05 PM
bex_77 bex_77 is offline Windows 7 32bit Office 2010 32bit
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

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