Google Sheets:
I have two google files. Lets call them "Data" and "Sales"
I need a formula in "Sales" cell that will search a column in "Data" by matching a cell value in "Sales" to a cell value in "Data".
I am familiar with importRange, index and vlookup formulas but am stuck.
Best Answer
example of such combination would be: