Looking up data based on more than one condition
I want to retrieve the value from column 'Particulars' on 'Sheet3' and its correspondent values from column 'Bill No.' and 'Amount' if the value from 'Particulars' column on 'Sheet3' is equal to the value from 'Particulars' column on 'Sheet2' and its correspondent value from column 'Quarter 1' on 'Sheet2' is greater than 0.
I want to do this with built-in formulas only if it could be done that way.
| Attachment | Size |
|---|---|
| C Form Pending (Padmawati Extrusion) - Copy.xlsx | 14.33 KB |

Recent comments
7 years 33 weeks ago
8 years 19 weeks ago
8 years 31 weeks ago
8 years 34 weeks ago
8 years 35 weeks ago
8 years 40 weeks ago
8 years 48 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago
8 years 49 weeks ago