Data validation forces entry in a range of cells.

**markDuffy** · 02-09-2012, 12:51 PM

Hi

Not sure it my description gave much of a clue.
I have a simple accounts sheet in Excel.
I do not as yet know VB. Just getting a handle on functions.

I have a column (E) of numbers, amounts paid out of the bank. I have a category column (G)which is populated with categories using data validation. I have columns to the right which are named as in the data validation options. Is there an automatic way that once the category has been chosen the amount be automatically entered in the appropriate column (drawings in the attached example) and in the same row P2.

Thanks to all who read this and a special thanks to anyone who has any suggestions as this would make what I am doing have less errors.

Mark

I am using excel 2010.

**TMS** · 02-09-2012, 01:54 PM

J2: =IF(J$1=$G2,$E2,"")

copy across and down

Regards, TMS

**markDuffy** · 02-10-2012, 08:29 AM

Fabulous. Such a small function so elegantly employed. Thanks a million

**TMS** · 02-10-2012, 08:46 AM

You're welcome. Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save