mr_shocker2002;1604329 Wrote:

Hi,

Happy to help but any chance you could provide at least a dummy
workbook?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101

Dear anyone that can help. i am new to functions and formulas in excel,
and only really use it in a basic way.

what i have is the following, two sheets with huge amounts of data on
cells.

A1 through to O1 has information on a piece of equipment.
A2 through to O2 is the same piece of equipment with different serial
number.
A3 through to O3 is a different piece of gear

A1 is AMP1001, A2 is Amp1002 A3 is AMP2001

on another sheet i have more information that i wish to put on the first
sheet

A1 is AMP1 i need the infomration from D1 through to M1 copied to the
first sheet to P1 through to z1
of course A2 needs the same information from the first cells.

A3 needs to copy the information from second sheet A2.

is there a formula that can lookup A1 on the first sheet, and if the
information on the second sheet has part of the same text (AMP1 or AMP2)
will copy to the first sheet?

i hope this makes sense.

thanks in advance for your help, it is very much appreciated.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
mr_shocker2002

mr_shocker2002;1604332 Wrote:

Hi,

Still struggling to understand exactly what you need here.

If you look up values from second tab into the first, would cells Q2, Q3
& Q4 all have the same value?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101

Spencer101;1604348 Wrote:

What i need to do is for Q2 through to AB2 to copy the data from the
second sheet of d2 through toO2.

but then on the q3 it would need to copy the same data.

when we get to q5 it would need to copy the data from d3

so AMP1 information on the data sheet neeeds to be copied to rows 2,3,4
and AMP2 information gets copied to rows 5,6,7,8


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
mr_shocker2002

mr_shocker2002;1604355 Wrote:

Could you not have just used the values in column B on each sheet as the
lookup value?

That's what I was going to suggest previously, but it seemed like too
obvious an answer to have been overlooked already.

From the sample data it would give the same results as yours.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101