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.

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_valuewas 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.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History