Urgent Help required !!!! - to deplay correct loop methodology are some other equivalent

Hi All

Could any one look in to my query and help me find the ideal looping methodology or equivalent technique to solve my request.

I have explained my requirement more in detail in the attachment.

Kindly reply me if more details required from me to understand the requirement.

Thanks in advance for the help!

Best
Rem0

Hi xladept

Thanks for looking in to my query.

Yes you are right! it should be b3 in authorizer sheet.

Thanks!
Rem0

=IF(D2="BS",IF(N2="Global",Authoriser!$B$2,""),IF(D2="CFG",IF(N2="Global",Authoriser!$B$3,""),""))

A simple if statement can give you what you need. See above. In the if statement above if D2 and N2 don't equal your request and blank is returned.

Hi Lakerftbl

Thanks for the input, the problem for me is the no of conditions going to be 30-35, so not sure it is worth doing it using IF statement.

Thanks for looking in to this.

I will try to implement formula in vba, once again thanks for the input.

Best
Rem0

Hi xladept

No there is no chance of N not be "Global", its definitely be global and i'm sure about it.

Best
Rem0

Hi xladept

Some more conditions for eg to give a closer look of my requirement.

Cond.3 ---> if d2 ='CB' and o2 = "" then y2 = b4 from authoriser sheet
Cond.4 ---> if d2 ='MID' and n2 = 'Global' and o2 = 'Asia' then y2 = b5 from authroiser sheet

This is how the logic is going to be, which means if any one condition is true it needs to pick the refered cell value in authoriser sheet.

Note: Each condition refers a unique authoriser cell value reference

Thanks again for looking in to this, as i'm already stuck with area with a point of no return. Any help on this will really help me a lot.

Best
Rem0

Hi -

How about this one?

Please Login or Register  to view this content.

Regards,
Event

Hi xladept and event21

Thanks for your inputs will look in to this and get back to you guys.

Best
Rem0

Hi Xladept

Sorry I was not quite clear about my requirement.

Actually the conditional combination also involves multiple range checks like below:

if e2 = "NV" and o2 = "Asia" then y2 = authoriser range b5
if g2 = "RS" and o2 ="America" then y2 = authoriser range b6

so, it gonna be like combining multiple For Each as per your code or do you have diff. idea?

Best
Rem0

Hi protonLeah

Thanks for the note.

I have been searching the edit option but can't find it, if you are a moderator can you help me amend the thread title or if you know one can you refer his/her name?

Best
Rem0

Hi xladept

Yes!

And moreover the code you given checks only d column whereas my requirement is to check d column and n column for 1 condition; e column and o column for 1 condition for each row until one of them is true.

Best
Rem0

Hi Xladept

Thanks for being patient.

I have revealed all the conditions here, only point is I dont want to refer the A column in authoriser sheet instead i would like to straight away refer the cell reference.

To reitrate again,

if i'm in 2 row of the OrgGeo, if d2 = Business sevices and N2 = Global then i want to refer corresponding y value from Authoriser sheet without using the reference of column A.

if this condition fails then next condition will be if d2 = CFG and o2 = Americas and p2 = "" then i want to refer y value from authoriser sheet without using the reference of column A.

thus, i want to check a sequence of conditions for each row till end of row.

Hope this clarifies!

Best
Rem0

Hi Xladept

Thanks this is what i required, however based on the timing factor I have choosed to Nested IF formula in VBA to serve my purpose.

Anyways Thanks a Trillion!

Best
Rem0