Tricky Formula to look up data

route217
route217 used Ask the Experts™
on
Hi Experts using Excel 2010

Need a formula to look in Sheet2 column(s) C6, and AC10 and if C6 is a “tick” wingding 2 (shift P) and AC 10 is Apples, then look in Sheet 1 Range C10:M100….and if column D10:D100 has a tick then return all the customer names in column C10:C100 and input those into Sheet2 Range C10:C30.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
your question is vague, can you please upload a sample.

what do you mean by Shift P
route217Junior

Author

Commented:
Shift P is a tick in wingdings a character
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
so that would mean to check against the font name and also font boldness correct?  for example if it is just capital P, then it should not trigger?
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

route217Junior

Author

Commented:
Just font name....If.there trigger if blank not there over on...
route217Junior

Author

Commented:
Array Formula
=iferror(vlookup(ac10&c6,choose{1,2},'sheet1'!d7&'sheet1'!d10:d29,'sheet1'!c10:c29),2,0),"")..

Works finds the first irration how do I find next in sequence...
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
i think there is a mistake in your abovementioned formula, how could you join two range not same size

is it a mistake  sheet1'!d7 is a single cell and sheet1'!d10:d29 is bunch of cells?

can you plz upload a sample file.
Microsoft Excel Expert
Top Expert 2014
Commented:
can you please open the attachment and see if that is what you are looking for?
EE.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial