route217

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.

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.

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?

ASKER

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

ASKER

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...

=iferror(vlookup(ac10&c6,c

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.

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

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
what do you mean by Shift P