I just want to know if its possible to use the IF
STATEMENT in Google Sheets by such algorithm as follows;
On Sheet1, from Cell A1
, I have a value blue
, and if the value inside the cell is blue
, it should be transferred in Sheet2, I don't know if the syntax is correct, but it's something like this.
=if A1 VALUE(Blue) then TRANSFER to sheet2 else FALSE;
Just to interpret how should it work, but I know the code is wrong. Any help will be greatly appreciated guys.
I'm not too clear if this is the result you want, but perhaps something similar:
=QUERY(Sheet1!A1:E19,"select A, D, C, E, B where A like 'makati%'",1)
See my added sheet, Makita-GK, in your sample.
Is that doing what you want? If not, please provide more details of what you want the result to be. Note that I added some data values in your Sheet1 data. If that isn't the type of data you have, please adjust it accordingly.
If necessary, please update your question to clarify the following.
Do you mean "where D='makati'...." or "where A='makati'...."? Column D is lastname in your sample data. Also, you had no data values with makati1 or makati2 in column A?