Excel combine two formula into one
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.
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:
Formula:
=IF(OR(VLOOKUP(Sheet2!B2,Sheet1!B:C,2,0)<>"TLE",VLOOKUP(Sheet2!B2,Sheet1!B:C,2,0)<>"CBF"),Sheet2!B2,"NO")
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".
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
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"))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks