If/Then formulas for text

Question

Level 1

4 points

If/Then formulas for text

I'd like to write a formula that extracts data from cell #K if cell #F contains a specific text to streamline my invoicing. In more detail, I have a spreadsheet where I itemize my receipts and invoices, group them into client categories, and create sums of what I purchased for each client (for example: receipt 05/01/19 = apples, tomatoes, bread for client A = $; carrots, pickles, applesauce for client B = $; jelly, ketchup, bagels for client C = $).

On the next spreadsheet, I reference the subtotals from the invoices to create weekly itemization and totals.

Is there a way to automate this process instead of directly referencing another sheet with the (=) function? Basically =IF((sheet1:F7="Pinschmidt")then(sheet2:c5=sheet1:K7))

MacBook Pro 13", macOS 10.14

Posted on May 6, 2019 9:23 PM

Reply

Answer 1

SGIII

Level 8

37,654 points

May 7, 2019 12:45 AM in response to Chedonna

It's hard to match your description with the screenshots. No invoice for 05/01/19, no apples, no tomato, no bread, no weekly itemization, etc.

Also bear in mind that a "sheet" in Numbers has a specific meaning that is different from how you are using it: a sheet doesn't have cells, whereas a table does.

It would be helpful if you could provide some clarity to your question, and exactly what you are trying to do.

SG

Reply