Solved Excel IF statement using google spreadsheet

November 3, 2012 at 09:37:30
Specs: Windows 7
Hello, I need some help with an excel sheet that I'm doing. I need an IF statement... IF columnA contains a certain value, then copy corresponding row values from columnB, columnC, columnD to another sheet (or preferably a different spreadsheet). Thanks for any help, this is my first time posting at this site.

See More: Excel IF statement using google spreadsheet

Report •

November 4, 2012 at 09:41:46
✔ Best Answer
Have you looked at the VLOOKUP function?

VLOOKUP can search the first column of a table and return values from other columns in the same Row. e.g.

=VLOOKUP(your_value, Sheet1!$A$1:$D$10,2,0)

will return the value from Column B of Sheet1 in the same Row that your_value was found.

You should note that the "2" in the formula does not correspond to Column B specifically, it refers to Column 2 of the table A1:D10. If the table was F1:H10, the 2 would refer to Column G, the 2nd Column in the table.

Search Google for VLOOKUP to get a more detailed explanation and some examples.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question