Excel combine two formula into one

[akulka58]

Hi All,

I am facing issue while combine two formula into one. In sheet1 I have two different outputs from two different formulas. I need only result in one column. I tried my level best however still not able to resolve it. Please refer attachment.

Please help out here. Thanks in advance.

[6StringJazzer]

I started to write a formula for you when I realized you have a serious logic problem in the formulas in column E. Here is a sample:

Please Login or Register  to view this content.

If VLOOKUP does not produce an error, your OR will always be TRUE. No matter what the VLOOKUP returns, the result will always be either not "TLE" or not "CBF".

What are you really trying to test for here? If you are trying to look for the opposite of the condition in the formula in column D, then maybe you want that OR to be an AND, meaning the result is neither "TLE" nor "CBF".

[FDibbins]

Try this....it is messy so I will see if I can simplify it...
=IFERROR(IF(OR(VLOOKUP(Sheet2!B2,Sheet1!B:C,2,0)<>"TLE",VLOOKUP(Sheet2!B2,Sheet1!B:C,2,0)<>"CBF"),Sheet2!B2,"NO"),IF(OR(VLOOKUP(Sheet2!A2,Sheet1!A:C,3,0)="TLE",VLOOKUP(Sheet2!A2,Sheet1!A:C,3,0)="CBF"),Sheet2!A2,"NO"))

[akulka58]

Hi 6StringJazzer,

Thanks for your reply. I need data based on column C i.e. if TLE or CBF is there then get data column A. The next part is I need value which is neither equal to TLE nor CBF however it should get values from column B. If my formula is incorrect then please advise a good formula which can achieve my object.

[akulka58]

Hi 6StringJazzer,,

We are near it however its failing when I changed data (I did not changed formula). Will you please have look into it. PFA