LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 131
Default Use lookup to write to cell

Hi,

in Cols B1, C1 & D1 I have dates 01/01/2008, 01/02/2008 & 03/01/2008,
in Rows A2, A3 & A4 I have names Tom, Dick & Harry,

In cell A10 is the value 'Dick'
In cell A11 is the value '02/01/2008'
In cell A12 is the value 'In'

Based on values in A10 - A11, I would like to insert the value of A12 to
cell (in this case C3), So C3 should show 'In'

Some solution in VBA would be great.

Many thanks & Happy New Year!

LaDDie


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CELL CONTENTS WRITE TO TAB NAME Jacob Skaria Excel Worksheet Functions 0 May 27th 10 10:47 PM
write in a cell and the cell above is temporarly hidden amuw Excel Worksheet Functions 0 June 18th 09 05:38 PM
Get Cell Address From Lookup (Alternative to Lookup) ryguy7272 Excel Worksheet Functions 12 September 28th 07 10:36 PM
Can I write an infinite amount in a cell with expanding the cell? adrnlnjnky Excel Discussion (Misc queries) 1 July 20th 07 10:32 AM
Question: Cell formula or macro to write result of one cell to another cell Frederik Romanov Excel Programming 1 July 8th 03 03:03 PM


All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"