VLOKUP used as 'Value_If_True" in If/Or" Formula

[kruss77]

Can VLOOKUP be used to satisfy one "values_if_True" components of an "If/OR" formula? I'm wondering because I'm trying to use VLOOKUP to work if one or another of two conditions is met. However, the following formula works only if:

CONDITION 1 and CONDITION 2 are met
CONDITION 1 is met and CONDITION 2 is not met

but NOT if

CONDITION 1 is not met but CONDITION 2 is met

=IF(OR(ISTEXT(C46),ISTEXT(B46)),VLOOKUP(B46,$S$6:$W$51,2,FALSE),"")


In other words:

C1 C2 Result
X...X..TRUE
X.......TRUE
.....X..FALSE

But it SHOULD yield a "true" in this last case, but doesn't in this formula.

Clearly, I'm doing something wrong. What am I missing?

Ken

 

[jtakw]

Hi,

What's in C46 and B46?

 

[kruss77]

A single letter "A", or "B", etc... Eventually, I might use single numbers as well "1", "2", etc...).

 

[mail2master]

There is nothing wrong with the formula but the data set you are providing as input I guess..
What is it that you want to test ?? Are you testing for TEXT or NON-BLANK CELL or something else ??
Please specify....

I assume, "column B" and "column S" has same data and you are trying to fetch value from "column T". Check if both the columns have actually same data...

 

[Fluff]

It would help if you explained what you were trying to do.
With you formula, if C46 was text & B46 was blank,then your Vlookup would trigger looking for a blank value.

 

[kruss77]

Ok, so after looking at this with fresh eyes, I realized my mistake and was able to correct it. It works now.

Thank everyone for looking.

 

[Fluff]

Glad you were able to sort it & thanks for the feedback