arrange columns through sheet and multi sheets

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
 
J

Jacob Skaria

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking data in 2 columns against a further 2 columns.... 1
Formula than understands midnight? 26
Copy columns and paste with blank column between 5
Pricing Analysis a bit convoluted 3
Criteria to return maximum value where x = x 3
Question regarding VLookup and if it can check two columns of data 2
Multiple chart creation using multiple series in the same row 1
Put data by matching cell value with sheet name 2

Top