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

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

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

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

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

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

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

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

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