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
Find Duplicates Across Two Sheets, Delete Everything else. 2
if query2- urgent requried 1
how to compare two columns on two sheets and copy associated data from one sheet to the other? 2
lookup over several columns 2
Refernce 2 sheets & same columns & rows 8
How Can i Link With one sheet to another sheet in Row to Column 1
Challenging Formula Issue 1

Top