auto populate

Hello HUW GARSTON,

You can use a simple IF if there are only 2 unique values on your C column, for example

=IF(C2="Submitted",100,25)

For B2, drag it down to B10.

100 if Submitted, 25 otherwise. If you have more than 2 unique values on C, you can nest IF within IF / use Lookup, etc

Use a nested IF statement. In B2:

Formula:

Please Login or Register  to view this content.

Drag this down the column as far as needed.
Replace "neither" with whatever you want to have in column B if C isn't either 'Submitted' or 'Non Possession work uploaded'. If you want it blank, use "".

Okay, with multiple conditions, although you can expand the IF statement, it starts to get a bit complicated and difficult to work out how to change it to add/delete other conditions later. So for this, I suggest using the following in B2 and drag down:

Formula:

Please Login or Register  to view this content.

It's an array formula, so enter it using Ctrl-Shift-Enter not just Enter. Excel will add curly brackets {} around the formula (don't enter them yourself).
If you later need to add/delete/change a condition, you can just amend the bits inside the curly brackets inside the formula.

Hope that helps (and makes sense!).


Edit: looking at the drop-down list you have in column C, you seem to have seven conditions, not the six listed in post 4, which doesn't mention the 'Non possession work uploaded' condition. Assuming you want that to give 25, as you said in your first post, the formula would be:

Formula:

Please Login or Register  to view this content.

You're welcome.