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 Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History