January 24, 2017
HI, I’m trying to make an excel formula that on sheet 2 ( 1 East) if an “x” is in column I on sheet 1(we’ll call “List”, it will return the value in column D on sheet 1 (“List”). If there is no data I want it to go to the next line and have no blanks on sheet 2. I’ve tried numerous times and have the if formula built, but then get blanks.
I've attached screen shots
This is my if formula: =IF(List!I11:I19=”X”,List!A11:A19,””)
When I try to use an IFERROR and SMALL with ROW formula:
=IFERROR(SMALL(IF(List!I11:I19=”X”,List!A11:A19,””) ,ROW()-2),””), I get blanks.
Please help. Thank you in advance!
June 25, 2016
Most Users Ever Online: 57
Currently Online: clark shao
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas