In Sheet2 row 1 place the necessary headers (which are similar to Sheet1
headers) and ColA with equipment name try the below formula in cell B2 .Then
copp/drag the formula across/down as required...This will pull the
corresponding information from Sheet1...

=VLOOKUP($A2,Sheet1!$A:$E,MATCH(B$1,Sheet1!$A$1:$E $1,0),0)

--
Jacob


"m.mohie" wrote:

good morning

A B C D
Equipment serial type model
mudump 123 triplex 1600hp

In another sheet

A B C D
Equipment serial model type
mudump 123 1600hp 1600hp

i need to collect "type" in column C without copy and paste because the data
is too wide more than those items