I would like to automatically update a column based upon information entered
in another column. Specifically, entering information into cells in, for
example, column A, have Excel find the exact match for an entry in column B,
& in that same row update the cell in column C with some pre-defined
information.
--
Thank you, Arnold

One way

Put in C1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
Copy down to the last row of data in col B, to return required results.

Replace "Yes" with the pre-defined info that you want inserted
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" wrote:
> I would like to automatically update a column based upon information entered
> in another column. Specifically, entering information into cells in, for
> example, column A, have Excel find the exact match for an entry in column B,
> & in that same row update the cell in column C with some pre-defined
> information.
> --
> Thank you, Arnold

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...
--
Thank you, Arnold


"Max" wrote:

> One way
>
> Put in C1:
> =IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
> Copy down to the last row of data in col B, to return required results.
>
> Replace "Yes" with the pre-defined info that you want inserted
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Arnold" wrote:
> > I would like to automatically update a column based upon information entered
> > in another column. Specifically, entering information into cells in, for
> > example, column A, have Excel find the exact match for an entry in column B,
> > & in that same row update the cell in column C with some pre-defined
> > information.
> > --
> > Thank you, Arnold

I do believe your suggestion will work. I've been thinking "forward" rather
than "reverse".

Each row is an account's information. Column A will have entered a 4-digit
number, an account number, indicating an account has been updated. Column B
contains the actual 4-digit account number for each row's account. Column C
contains the date the account was last updated. Entering your statement into
column C directs it to check its value in column B with the values in column
A &, if it finds a match in column A, then update its value in column C with
"x", otherwise leave blank. However, rather than leaving column C blank, I'd
rather leave the value already there intact. I can accomplish this by...
--
Thank you, Arnold


"Max" wrote:

> One way
>
> Put in C1:
> =IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
> Copy down to the last row of data in col B, to return required results.
>
> Replace "Yes" with the pre-defined info that you want inserted
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Arnold" wrote:
> > I would like to automatically update a column based upon information entered
> > in another column. Specifically, entering information into cells in, for
> > example, column A, have Excel find the exact match for an entry in column B,
> > & in that same row update the cell in column C with some pre-defined
> > information.
> > --
> > Thank you, Arnold

I should also note, the "numbers" in columns A & B are formatted as text,
because many start with a zero. Thanks again.

"Max" wrote:

> One way
>
> Put in C1:
> =IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","")
> Copy down to the last row of data in col B, to return required results.
>
> Replace "Yes" with the pre-defined info that you want inserted
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Arnold" wrote:
> > I would like to automatically update a column based upon information entered
> > in another column. Specifically, entering information into cells in, for
> > example, column A, have Excel find the exact match for an entry in column B,
> > & in that same row update the cell in column C with some pre-defined
> > information.
> > --
> > Thank you, Arnold

Ref your elaborations. Try inserting a new col D for the revised formula
below. Format col D as date. I'll presume you want the current date (ie
today's date) to be returned where the acc no. in B1 is found within the
"updated" list of acc nos in col A. If the acc no. is not found, then to
return its existing value (ie the previous date) in col C, if there is any.
And if there is no existing date in col C, to return a blank: "" (you didn't
mention this possibility, but I'm catering for it).

Put in D1:
=IF(ISNUMBER(MATCH(B1,A:A,0)),TODAY(),IF(C1="","",C1))
Copy down to the last row of data in col B. Select col D, kill the formulas
with an "in-place" copy n paste special as values. Then delete col C. The
"new" col C (ie the ex-col D) is your update for the day. Just repeat the
process at the end of each day.

Pl click the "Yes" button from where you're reading this,
if this post was helpful to you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" <(E-Mail Removed)> wrote in message
news:70AE7427-76BE-4EF9-8159-(E-Mail Removed)...
>I should also note, the "numbers" in columns A & B are formatted as text,
> because many start with a zero. Thanks again.

>I do believe your suggestion will work. I've been thinking "forward" rather
> than "reverse".
>
> Each row is an account's information. Column A will have entered a 4-digit
> number, an account number, indicating an account has been updated. Column B
> contains the actual 4-digit account number for each row's account. Column C
> contains the date the account was last updated. Entering your statement into
> column C directs it to check its value in column B with the values in column
> A &, if it finds a match in column A, then update its value in column C with
> "x", otherwise leave blank. However, rather than leaving column C blank, I'd
> rather leave the value already there intact. I can accomplish this by...

Yes, this new formula covers all the bases. With regards to TODAY(), if I
wanted another date, I could type "10/1/07", for example, to have it
inserted. Yes, this seems to have it. Thank you very much, Max.

"Max" wrote:

> Ref your elaborations. Try inserting a new col D for the revised formula
> below. Format col D as date. I'll presume you want the current date (ie
> today's date) to be returned where the acc no. in B1 is found within the
> "updated" list of acc nos in col A. If the acc no. is not found, then to
> return its existing value (ie the previous date) in col C, if there is any.
> And if there is no existing date in col C, to return a blank: "" (you didn't
> mention this possibility, but I'm catering for it).
>
> Put in D1:
> =IF(ISNUMBER(MATCH(B1,A:A,0)),TODAY(),IF(C1="","",C1))
> Copy down to the last row of data in col B. Select col D, kill the formulas
> with an "in-place" copy n paste special as values. Then delete col C. The
> "new" col C (ie the ex-col D) is your update for the day. Just repeat the
> process at the end of each day.
>
> Pl click the "Yes" button from where you're reading this,
> if this post was helpful to you.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Arnold" <(E-Mail Removed)> wrote in message
> news:70AE7427-76BE-4EF9-8159-(E-Mail Removed)...
> >I should also note, the "numbers" in columns A & B are formatted as text,
> > because many start with a zero. Thanks again.
>
> >I do believe your suggestion will work. I've been thinking "forward" rather
> > than "reverse".
> >
> > Each row is an account's information. Column A will have entered a 4-digit
> > number, an account number, indicating an account has been updated. Column B
> > contains the actual 4-digit account number for each row's account. Column C
> > contains the date the account was last updated. Entering your statement into
> > column C directs it to check its value in column B with the values in column
> > A &, if it finds a match in column A, then update its value in column C with
> > "x", otherwise leave blank. However, rather than leaving column C blank, I'd
> > rather leave the value already there intact. I can accomplish this by...
>

welcome, Arnold.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" <(E-Mail Removed)> wrote in message
news:1146FBCD-88A8-48C0-8F8A-(E-Mail Removed)...
> Yes, this new formula covers all the bases. With regards to TODAY(), if I
> wanted another date, I could type "10/1/07", for example, to have it
> inserted. Yes, this seems to have it. Thank you very much, Max.

Hi, Max,

Wanted to take a moment to thank you. Your suggestion works like a charm!
Absolutely handles the situation.

Thanks again,
Arnold


"Max" wrote:

> welcome, Arnold.
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Arnold" <(E-Mail Removed)> wrote in message
> news:1146FBCD-88A8-48C0-8F8A-(E-Mail Removed)...
> > Yes, this new formula covers all the bases. With regards to TODAY(), if I
> > wanted another date, I could type "10/1/07", for example, to have it
> > inserted. Yes, this seems to have it. Thank you very much, Max.
>
>
>

Moments appreciated, Arnold.
Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arnold" <(E-Mail Removed)> wrote in message
news:BFC84330-BDD5-48C0-8411-(E-Mail Removed)...
> Hi, Max,
>
> Wanted to take a moment to thank you. Your suggestion works like a charm!
> Absolutely handles the situation.
>
> Thanks again,
> Arnold