Need assistance with returning another column result in the same If(or Statement

Hi,


Here is my formulae...

Please Login or Register  to view this content.

For the above portion of the IF(OR .... that is "Unidentified Existing" , I want to Vlookup on another column as well as what is listed to include in the formulae. What would be the logice to do so? -the Column i would need returned is Col P

What would I need to do to update?

Do you want the lookup as part of the logical test, or as part of the result?

If part of the logical test, what do we compare to?

Originally Posted by swade730

What would I need to do to update?

Your post, it's just a little to brief to make sense.

Originally Posted by jason.b75

Do you want the lookup as part of the logical test, or as part of the result?

If part of the logical test, what do we compare to?



Your post, it's just a little to brief to make sense.

it would need to be as part of the logical result but based on that condition where it reads Unidentified Existing, I would need it to return a different column. So part of the all logical test, but one part is returning a different column

I've shortened the first part of the formula to make it a bit easier to follow.

=IFERROR(LOOKUP($S539,{"RBG","Financial ","Pub"}),IF(OR($C539="Unidentified EXISTING CLIENT",$C539="Unidentified NEW CLIENT"),VLOOKUP($AC539,Tags!$B$4:$P$534,IF($C539="unidentified exising",15,1),FALSE),VLOOKUP($C539,Tags!$A$4:$L$534,2,FALSE)))

Criteria removed from OR() function and logical test used in column argument of VLOOKUP.

Originally Posted by jason.b75

I've shortened the first part of the formula to make it a bit easier to follow.

=IFERROR(LOOKUP($S539,{"RBG","Financial ","Pub"}),IF(OR($C539="Unidentified EXISTING CLIENT",$C539="Unidentified NEW CLIENT"),VLOOKUP($AC539,Tags!$B$4:$P$534,IF($C539="unidentified exising",15,1),FALSE),VLOOKUP($C539,Tags!$A$4:$L$534,2,FALSE)))

Criteria removed from OR() function and logical test used in column argument of VLOOKUP.

Everytime I hit enter, the dialougue box pops up. Also, why the '15'?

Excel has many different dialogue boxes, I can't see which one you are getting from here.

You said column P, which is the 15th column in the range B:P

Originally Posted by jason.b75

I've shortened the first part of the formula to make it a bit easier to follow.

=IFERROR(LOOKUP($S539,{"RBG","Financial ","Pub"}),IF(OR($C539="Unidentified EXISTING CLIENT",$C539="Unidentified NEW CLIENT"),VLOOKUP($AC539,Tags!$B$4:$P$534,IF($C539="unidentified exising",15,1),FALSE),VLOOKUP($C539,Tags!$A$4:$L$534,2,FALSE)))

Criteria removed from OR() function and logical test used in column argument of VLOOKUP.

Is it possible to do this with the OR() function not removed?

I haven't removed the OR function, just one part of it. My suggestion is based on the very little amount of information you have provided us with.

Given that you provide answers to questions as aking them, I would have thought that you would understand the importance of providing sufficient information.

If you're asking, can you have different results from one OR function, then the answer is no, for that you would need something on the lines of CHOOSE(MATCH(....

Originally Posted by jason.b75

I haven't removed the OR function, just one part of it. My suggestion is based on the very little amount of information you have provided us with.

Given that you provide answers to questions as aking them, I would have thought that you would understand the importance of providing sufficient information.

If you're asking, can you have different results from one OR function, then the answer is no, for that you would need something on the lines of CHOOSE(MATCH(....

Im going to attach a workbook

The site won't allow me to attach a workbook, So I will try to clarify my original post in more detail...

Here is my formulae...

Please Login or Register  to view this content.

The values being returned for the "Unidentified Existing" part are the same as the initial returned value...

For Example if my data looks like this...

Col A Col B
Unidentified Existing Swade730
Unidentified Existing Gatti

My results (when the Unidentified Existing is TRUE) Should return the CORRESPONDING Col B value. - Instead I am only seeing Swade730.

and Also, if the Unidentified Existing is True and there is no name returned from the column I want...how can I direct this to show the value from another column?

What would I need to do to update?

I'm going to guess that you're using windows edge, that seems to have issues attaching files to the forum.

Click the ... icon in the top right of the browser, then open with internet explorer and try again.

VLOOKUP will only return the record from the first matching row, without seeing how you're getting to the next row, I don't know what to suggest.

Given that you have started several new threads since the last activity in this one, can we assume that this issue is now either resolved or abandoned?