Google Product Forums
Re: function to match the value on 2 sheet
MarinusP Jun 27, 2012 12:32 AM
Posted in group: Google Docs

Categories: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

Hi

I added an extra column to sheet1 with in cell G1, I modified your existing formula a little bit:

=ARRAYFORMULA(IF(ROW(F:F)=1;"Price MP";VLOOKUP(B:B,Sheet2!B:D;3*SIGN(ROW(F:F));)))

I hope this helps. Please let me know if you have questions or suggestions.