Avatar of route217
Flag 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.
Microsoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon