Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
In B2 add
=IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
Thanks bob,
Happy New Year!! "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
Bob,
is there a way for this formula to return the target cell address? Thanks "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
What are you calling target in this instance, A12?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... Bob, is there a way for this formula to return the target cell address? Thanks "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
What i'm trying to achive is a method to display the looked up cell address
in say cell A13. Thanks, LaDDie "Bob Phillips" wrote: What are you calling target in this instance, A12? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... Bob, is there a way for this formula to return the target cell address? Thanks "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
Use this in A13
=ADDRESS(MATCH(A10,A1:A4,0),MATCH(A11,A1:D1,0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... What i'm trying to achive is a method to display the looked up cell address in say cell A13. Thanks, LaDDie "Bob Phillips" wrote: What are you calling target in this instance, A12? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... Bob, is there a way for this formula to return the target cell address? Thanks "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup to write to cell
Thanks again Bob, just the thing I was looking for.
Happy New Year! LaDDie "Bob Phillips" wrote: Use this in A13 =ADDRESS(MATCH(A10,A1:A4,0),MATCH(A11,A1:D1,0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... What i'm trying to achive is a method to display the looked up cell address in say cell A13. Thanks, LaDDie "Bob Phillips" wrote: What are you calling target in this instance, A12? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LaDdIe" wrote in message ... Bob, is there a way for this formula to return the target cell address? Thanks "Bob Phillips" wrote: In B2 add =IF(AND(B$1=$A$11,$A2=$A$10),$A$12,"") and copy across and down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL CONTENTS WRITE TO TAB NAME | Excel Worksheet Functions | |||
write in a cell and the cell above is temporarly hidden | Excel Worksheet Functions | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Can I write an infinite amount in a cell with expanding the cell? | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |