Google-sheets – Compare two rows of a sheet to another and show characteristics

google sheets

I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products (Company/S.N./Quality). As:

PRODUCTS

And on a second spreadsheet (INVENTORY), I can see what we have in stock.

INVENTORY

I would like to be able to see the quality of each of the products we have in stock. Like in this image:
enter image description here

I tried some kinds of IF and ArrayFormula… I understand it should be an easy problem, but I'm not a clever man.

Best Answer

There are cleverer ways of doing this but the conventional solution is to add a 'helper' column:

Insert a column at the extreme left of PRODUCTS and in A1:
```
=B1&"|"&C1  
```

and copy down to suit.

In INVENTORY in C2 insert:
```
=VLOOKUP(A2&"|"&B2,Products!A:D,4,0)  
```

and copy down to suit.

Related Solutions

Google Sheets – Compare Each Cell of Two Rows in Google Sheets

Try this:

=arrayformula(sumproduct((T2:AM2=T3:AM3)))

What this will do is compare each cell, return a 0 or 1 if true, and then sum up the counts.

Arrayformula() is a way to apply a function to an array, rather than a single cell.

Google-sheets – How to make a simple two column data chart in Google Spreadsheets

Maybe this has been fixed in New Google Sheets because it works for me (indeed, it is VERY simple):

WA47150 example

Select A1:B3, Insert, Chart..., click Line chart, Insert.

Seems happy to work with DMY format and, as it happens, text for dates (since happening to be 4 months apart the x-axis spacing to be equal is about correct anyway).

Best Answer

Related Solutions

Google Sheets – Compare Each Cell of Two Rows in Google Sheets

Google-sheets – How to make a simple two column data chart in Google Spreadsheets

Related Topic