Multi Condition Logic Formula

[nhbartos]

Hi folks,

I need some help with a formula.

Column F, rows 6 to 1000 contain drop-down lists with the following codes and range:

Drop-down selections:
H2019 is in cell N6
H2020 is in cell N7
H2021 is in cell N8

Minute's location:
15 is in cell O6
30 is in cell O7
30 is in cell O8

In column H, H6 down, I need a logic formula for multiple conditions.

If F6 = H2019 then divide E6/O6
If F6 = H2020 then divide E6/O7
If F6 = H2021 then divide E6/O8

The cells from H6 down should remain blank until a selection is made in F.

Thanks!

 

[Aladin Akyurek]

Re: Multi Condition Logic Formula Help Needed

Something like:

=IF(F6="","",E6/VLOOKUP(F6,$N$6:$O$8,2,0))

 

[nhbartos]

Re: Multi Condition Logic Formula Help Needed

So jealous of you guys who can just bang this stuff out!
Thanks a lot. It is perfect.

 

[Aladin Akyurek]

Re: Multi Condition Logic Formula Help Needed

So jealous of you guys who can just bang this stuff out!
Thanks a lot. It is perfect.

You are welcome.

 

[nhbartos]

Re: Multi Condition Logic Formula Help Needed

Hello Aladin,

Do you have time for another challenge? This one may be tough.
I have my file here if you need it: RSC Billing Template_8-23-17_Test.xlsm - Google Drive

The formula I need is going to be in The H column, Insurance Company, from H6, down to row 500.

I am not sure you can do this with so many ' variables', but here it is...

H6 formula:

If...
Student 1 is shown in cell A6, insert insurance company name located in cell K6 into H6, and insert L6 into F6
If...
Student 2 is shown in cell A6, insert insurance company name located in cell K7 into H7, and insert L7 into F7
If...

There can be up to 200 students listed in column J, from J6:J205.

If there is no student name in column A, columns F and H should be blank.

Vince

 

[nhbartos]

Re: Multi Condition Logic Formula Help Needed

SORRY!!!...Ignore the previous message. I had listed what I needed incorrectly.
Below is correct.

Do you have time for another challenge? This one may be tough, if possible at all.
I have my file here if you need it: RSC Billing Template_8-23-17_Test.xlsm - Google Drive

The formula I need is going to be in the H column, Insurance Company, from H6, down to row 500.

I am not sure you can do this with so many ' variables', but here it is...

Formula for H6:

If...
Student 1 is in cell A6, Look for Student 1 in column J.
If student 1 is in column J, insert contents of column K (same row), into column H (same row).
If student 1 is in columns J, insert contents of column L (same row), into column F (same row).

If...
Student 2 is in cell A6, Look for Student 2 in column J.
If student 2 is in column J, insert contents of column K (same row), into column H (same row).
If student 2 is in columns J, insert contents of column L (same row), into column F (same row).

If...
Student 3 is in cell A6, Look for Student 3 in column J.
If student 3 is in column J, insert contents of column K (same row), into column H (same row).
If student 3 is in columns J, insert contents of column L (same row), into column F (same row).

etc...

There can be up to 200 students listed in column J, from J6:J205.

If there is no student name in column A, columns F and H should be blank.

Vince

 

[Aladin Akyurek]

Re: Multi Condition Logic Formula Help Needed

Have a look at the VLOOKUP function, something like:

=VLOOKUP($A6,J:K,2,0)

 

[nhbartos]

Re: Multi Condition Logic Formula Help Needed

Once again, thank you!
I now understand vlookup, now that I see it in a familiar context.
Again, thanks.
Peace -

 

[Aladin Akyurek]

Re: Multi Condition Logic Formula Help Needed

Once again, thank you!
I now understand vlookup, now that I see it in a familiar context.
Again, thanks.
Peace -

You are welcome.