An VLOOKUP or INDEX formula for the following.

HYG_Support

I don't want to link the cells to the other sheet. I need a formula that will take the value from each column from my "Task Sheet" and enter the data in the same rows of my "IT Sheet".

Genevieve P.

Hi @HYG_Support

An INDEX(MATCH formula will do this for you, as long as you have a unique matching value across both sheets:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

or

=INDEX({Column to return}, MATCH([Matching Value]@row, {Column with value to match}, 0))

This article has more information and some alternatives:

https://help.smartsheet.com/articles/2482647-cross-sheet-formula-combinations

Cheers,

Genevieve