Link to home
Start Free TrialLog in
Avatar of route217
route217Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Tricky Formula to look up data

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.
Avatar of Professor J
Professor J

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

what do you mean by Shift P
Avatar of route217

ASKER

Shift P is a tick in wingdings a character
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?
Just font name....If.there trigger if blank not there over on...
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...
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.
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial