Jul 13, 2010 at 08:04 AM
Posts4479Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Jul 13, 2010 at 08:12 AM
What formula to use in excel if i want to find a value in particualr cell satisfying more than 1 condition.say,i have date range in column A,buyer range in column B and I have target value in column C.
Example- A1=1july b1=A&F c1=20
A2=1july b2=maggie c2=34
Nowif i want to find target value for A&F for 1july in column D,then what will be the formula.