arrange columns through sheet and multi sheets

  • Thread starter Thread starter m.mohie
  • Start date Start date
M

m.mohie

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
 
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)
 
Back
Top