'If' Macro

**jamessaunders** · 08-16-2007, 06:26 AM

I need to change cell values according to code entered into another cell:

For example:

If 'A' is entered into cell A1, I would like B1 to contain 'Richard' and cell C1 to contain 'Bartram'

If 'B' is entered into cell A1, I would like B1 to contain 'Lee' and cell C1 to contain 'Farquar'

If 'C' is entered into cell A1, I would like B1 to contain 'Andrew' and cell C1 to contain 'Gutteridge'

There are 21 codes for Cell A (21 possible names for B1,C1) and approx 2000 rows in column A to input a code.

I know I can't use an IF funtion, but could anybody help with a Macro?

Best wishes,

James

**royUK** · 08-16-2007, 07:34 AM

Why not use VLOOKUP?

**jamessaunders** · 08-16-2007, 08:12 AM

Not getting that to work effectively

**boylejob** · 08-16-2007, 10:02 AM

James,

Do you have your name pairs currently set up on a worksheet within the workbook? If so, then I believe you could do something similar to what we have done with your planner. As soon as a code is entered in column A it finds the code on the other sheet, grabs the names, and puts them in columns B & C. It that basically what you are wanting to do.

You might want to post a sample like you did with your planner. That will make it a lot easier to help you.