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?