Thread
:
Use lookup to write to cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
Use lookup to write to cell
So what are the 'rules' you base the selection upon?
--
Regards,
Nigel
"LaDdIe" wrote in message
...
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
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]