- Joined
- Mar 16, 2008
- Messages
- 4
- Reaction score
- 0
im trying to use a function with excell & i'm not really sure which formula to use, ive tried vlookup, hlookup, lookup, if, match etc, heres my problem . .
in sheet 'dates' i have the date in cell A1-A30 where A1 is 01/01/08, i want to match this date with the same date on another sheet 'customers' but the same date could be on any row, each row contains details of a customer. the customer sheet starts name(columnA), street(columnB),post code(columnC), date(columnD). what i want to do is if cell A1 on sheet 'dates' = a cell in columnD of 'customer' sheet the display customer details ($1,$2,$3 of the row where that date is found) in cellA2,A3,A4 of 'dates'. Sorry if it sounds confusing but any help would be greatly appreciated, thx.
i'll try to display an example -
'customers'
. . . .A. . . . . . . .B . . . . . . .C. . . . . . . .D
1 joe blogg . grey street . wv3 344 . 02/01/08
2 matt job . brown road . w43 332 . 01/01/08 <- looking for this
3 ray quinn . red avenue . w22 321 . 10/01/08
'dates'
. . . . \/ (A1) - if this cell = a cell in column D on 'customers'
. . . .A. . . . . . . .B . . . . . . .C. . . . . . . .D
1 01/01/08 . matt job . brown road . w43 332
2 02/01/08 . . . ./\
3 03/01/08 where i want formula
. . . /\
. . dates
in sheet 'dates' i have the date in cell A1-A30 where A1 is 01/01/08, i want to match this date with the same date on another sheet 'customers' but the same date could be on any row, each row contains details of a customer. the customer sheet starts name(columnA), street(columnB),post code(columnC), date(columnD). what i want to do is if cell A1 on sheet 'dates' = a cell in columnD of 'customer' sheet the display customer details ($1,$2,$3 of the row where that date is found) in cellA2,A3,A4 of 'dates'. Sorry if it sounds confusing but any help would be greatly appreciated, thx.
i'll try to display an example -
'customers'
. . . .A. . . . . . . .B . . . . . . .C. . . . . . . .D
1 joe blogg . grey street . wv3 344 . 02/01/08
2 matt job . brown road . w43 332 . 01/01/08 <- looking for this
3 ray quinn . red avenue . w22 321 . 10/01/08
'dates'
. . . . \/ (A1) - if this cell = a cell in column D on 'customers'
. . . .A. . . . . . . .B . . . . . . .C. . . . . . . .D
1 01/01/08 . matt job . brown road . w43 332
2 02/01/08 . . . ./\
3 03/01/08 where i want formula
. . . /\
. . dates