[AccessD] OT - Can Anyone Help With Excel Problem

Hi Paul!

I think I know what you are after.

Do a search in Excel help for VLOOKUP and HLOOKUP.

If you need any more help could you please send me your spreadsheet file at
my 'home' address of spikee at oatlandspark dot org dot uk . 

Regards
Chris Foote - UK

> -----Original Message-----
> From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
> Sent: Friday, May 06, 2005 9:45 AM
> To: accessd
> Subject: [AccessD] OT - Can Anyone Help With Excel Problem
> 
> 
> To all,
> 
> I Have a workbook which contains two sheets, 
> sheet1 is a plan sheet with Date (dd/mm/yy) (Col A), Day 
> (Monday etc) (Col 2) (roughly about 291 dates/days).  Row 1 
> contains Area's.
> sheet2 has a list of store names (Col A) and store numbers 
> (Col B) and a blank date field (Col C).
> What I need to achieve is if a store number is entered into 
> sheet1 underneath an area and next to a date, I need to look 
> up that store number in sheet2 and put the date into Col C
> 
> Has anyone any idea on the best way to do this, I have messed 
> about with simple macros before now but not do anything like 
> this in Excel before......
> 
> If I have managed to confuse anyone on what I need to 
> achieve, I will happily email a sample sheet off-line
> 
> Thanks in advance for all you help....
> 
> Paul Hartland
> 
> -- 
> 
> Whatever you Wanadoo:
> http://www.wanadoo.co.uk/time/
> 
> This email has been checked for most known viruses - find out 
> more at: http://www.wanadoo.co.uk/help/id/7098.htm
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>