Google Sheets – How to Refer Values in Other Column by Key (Like SQL Join)

google sheetsgoogle-apps

I have a sheet/document with item number and it's price.
In an invoice, I have:

| Number | Qty | Price | ... | Total price
| 21     | 3   |  ???  | ... | = C2 * B2

I'd like the Price column to be filled by looking up the value from other sheet or document, i.e. something like

=LOOKUP( PricesSheet, Column C, row with value from A2).

Basically, I want a SQL join functionality.

How can I do that?

Best Answer

Please try something like:

=vlookup(A1,Sheet2!H:I,2,0)

where ColumnH in Sheet2 ('other sheet') contains Number and ColumnI of the same row the corresponding unit price.

Related Solutions

Google-sheets – How to get value of cell by row key and column key

If you're looking for just the GDP of France then this will do:

=VLOOKUP("France",data!A2:C,2,FALSE)

Google Sheets – How to Perform SQL JOIN and SUM Equivalent

This is what I think you're looking for:

Formula

=QUERY(DATA!B1:C3;"SELECT B, SUM(C) GROUP BY B label B 'Type', SUM(C) 'Sum'")

Explained

Column C is aggregated by column B through a summation. Labels are added. In this particular case, the usage of JOIN in an SQL statement isn't applicable, since the aggregation is done on one table.

Screenshots

Data:
data

Result
result

Example

I've created an example file for you: Sum Aggregate