Well, I couldn't give more detailed and specific help because your
description was a bit vague. Tell me how your data is laid out - the
columns you use, whether you have headers, sheet names etc. It would
also help if you could post some example data, showing what you have
and what you want to achieve.

Pete

On Jan 23, 8:29*pm, Oscar wrote:
I went that route already, but I'm having a hard time putting together a
formula. I don't know how to start it



"Pete_UK" wrote:
Check out VLOOKUP in Excel Help.

Hope this helps.

Pete

On Jan 23, 2:25 pm, Oscar wrote:
Hi,

I have a spreadsheet were I keep account info. Each account has a status on
sheet 2. Each time I work on these accounts I enter a dexcription on the
status colum to help me organize the status of the account. On sheet 1 cell D
I have the same column. Each week I get a report with updated accounts that I
add to my existing spreadsheet. I copy the new loans in sheet 1 column A.
Since most of these loans are repeats from previous weeks I most likely have
a comment on some of those loan in sheet 2. I would like to enter a formula
in sheet 1 column D that would match the account number from column A and
sheet 2 column E loan number. When it finds its match I would like to
formuala to update the cell with the comment that I already enter in sheet 2
column C. This will help me know which loans are new and which loans I
already worked on and know what the status is.

I hope I make sense

Thanks- Hide quoted text -

- Show quoted text -