Forum Discussion
Help - vlookup not my friend
Can anyone help me, I’m sure this can be done. I have a MASTER spreadsheet with all data on, I want the master spreadsheet data to stay as is but, I need specific entire row data to be pulled to ...
Thank you for your recommendation, I am not sure if I am doing something wrong so I have changed titles to match exactly what you have, but its not working at all it gives me an error message (see screen shot below), Any advice would be amazing.
This "FILTER" function feels familiar and like what I need, its been a while for me so I am rusty.
If yo use comma as decimal separator, use semicolon instead of comma between the arguments of a function:
=FILTER(Data;Data[Supplier]="ACME";"")