Searching a list of names, with corsponding data across to another worksheet

[Butch-196]

Hi
I have a list of poeple that have use water.

Name - Date - start meter reading - end meter reading etc.

I need to seach the list via the name and then copy the Name - Date etc across to a new worksheet.

Note, - name maybe listed more than once so I need to look at the complete list and import the data for each time the name is entered

is lookup the right function

regards
richard

 

[aqeelnokia99]

use vlookup and to get date start meter ets use coloms($A$1:A1)+1 in coloms number

 

[Butch-196]

Please see below and explain further

[TABLE="width: 501"]
<colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 8587;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2676;"> <col width="181" style="width: 136pt; mso-width-source: userset; mso-width-alt: 6330;"> <col width="163" style="width: 122pt; mso-width-source: userset; mso-width-alt: 5678;"> <tbody>[TR]
[TD="width: 246, bgcolor: transparent"]Name [/TD]
[TD="width: 77, bgcolor: transparent"]Date[/TD]
[TD="width: 344, bgcolor: transparent, colspan: 2"]Meter Reading[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Start [/TD]
[TD="bgcolor: transparent"]End [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]12/03/2018[/TD]
[TD="bgcolor: transparent"]796908.30[/TD]
[TD="bgcolor: transparent"]796943.30[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]OUTRAM[/TD]
[TD="bgcolor: transparent"]13/03/2018[/TD]
[TD="bgcolor: transparent"]796943.30[/TD]
[TD="bgcolor: transparent"]796982.10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILSON[/TD]
[TD="bgcolor: transparent"]14/03/2018[/TD]
[TD="bgcolor: transparent"]796982.10[/TD]
[TD="bgcolor: transparent"]797120.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]DUCKER[/TD]
[TD="bgcolor: transparent"]15/03/2018[/TD]
[TD="bgcolor: transparent"]797120.00[/TD]
[TD="bgcolor: transparent"]797140.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]FRYATT[/TD]
[TD="bgcolor: transparent"]16/03/2018[/TD]
[TD="bgcolor: transparent"]797140.00[/TD]
[TD="bgcolor: transparent"]797155.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]IBBOTSON[/TD]
[TD="bgcolor: transparent"]17/03/2018[/TD]
[TD="bgcolor: transparent"]797155.00[/TD]
[TD="bgcolor: transparent"]797222.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]KIRBY[/TD]
[TD="bgcolor: transparent"]18/03/2018[/TD]
[TD="bgcolor: transparent"]797222.00[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]19/03/2018[/TD]
[TD="bgcolor: transparent"]797289.00[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILSON[/TD]
[TD="bgcolor: transparent"]20/03/2018[/TD]
[TD="bgcolor: transparent"]797389.00[/TD]
[TD="bgcolor: transparent"]797489.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WOODCOCK[/TD]
[TD="bgcolor: transparent"]21/03/2018[/TD]
[TD="bgcolor: transparent"]797489.00[/TD]
[TD="bgcolor: transparent"]797589.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]SMITH[/TD]
[TD="bgcolor: transparent"]22/03/2018[/TD]
[TD="bgcolor: transparent"]797589.00[/TD]
[TD="bgcolor: transparent"]797689.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WITHERS C[/TD]
[TD="bgcolor: transparent"]23/03/2018[/TD]
[TD="bgcolor: transparent"]797689.00[/TD]
[TD="bgcolor: transparent"]797789.00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]WILLIAMS[/TD]
[TD="bgcolor: transparent"]24/03/2018[/TD]
[TD="bgcolor: transparent"]797789.00[/TD]
[TD="bgcolor: transparent"]797889.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J
1	Name	Date	Start	End
2	Peter	01/12/1997	83	183			Paul	01/10/1987	85	185
3	Paul	01/10/1987	85	185				01/01/1980	116	216
4	Peter	01/01/1980	67	167				01/03/2004	126	226
5	Peter	01/01/1980	78	178				01/08/2016	92	192
6	Peter	01/07/2005	77	177				01/04/1985	88	188
7	Peter	01/01/1980	96	196				01/01/1980	92	192
8	Paul	01/01/1980	116	216				01/01/1980	106	206
9	Mary	01/10/2016	105	205
10	Paul	01/03/2004	126	226
11	Paul	01/08/2016	92	192
12	Paul	01/04/1985	88	188
13	Peter	01/06/1997	102	202
14	Peter	01/04/1986	117	217
15	Peter	01/01/1980	103	203
16	Peter	01/01/1980	111	211
17	Peter	01/12/2000	95	195
18	Paul	01/01/1980	92	192
19	Paul	01/01/1980	106	206
sheet1

Cell Formulas
Range	Formula
H2	{=IFERROR(INDEX(B$2:B$27,SMALL(IF($A$2:$A$27=$G$2,ROW($A$2:$A$27)-ROW($A$2)+1),ROWS($1:1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

Formula copied across & down