# Could you tell me why the second half on this formula is not working?

1. ## Could you tell me why the second half on this formula is not working?

So the "WST" formula is working perfectly but the "MAXIMS" just seems to keep coming back with "FALSE". If i split the two formulas they both work independently. Any help would be much appreciated!

=IF(C8="WST",IF(I8="","",VLOOKUP(J8,Data!B:H,7,IF(C8="MAXIMS",IF(I8="","",VLOOKUP(J8,Data!B:I,8,FALSE))))))

Thanks!!  Register To Reply

2. ## Re: Could you tell me why the second half on this formula is not working?

Try
=if(c8="wst",if(i8="","",vlookup(j8,data!b:h,7,0)),if(c8="maxims",if(i8="","",vlookup(j8,data!b:i,8,false))))  Register To Reply

3. ## Re: Could you tell me why the second half on this formula is not working?

HI,

Unfortunately this has done the same as earlier and has come out with the same answer as the "first half". The answer to the first half is in tab DATA column H and the second half should be from column I, if this helps at all?  Register To Reply

4. ## Re: Could you tell me why the second half on this formula is not working?

=IF(C8="","",VLOOKUP(J8,Data!B:I,7+(C8<>"wst"),0))  Register To Reply

5. ## Re: Could you tell me why the second half on this formula is not working?

The exact same issue again, reading the answer for "WST" with either option.  Register To Reply

6. ## Re: Could you tell me why the second half on this formula is not working?

Make sure that all confidential data is removed or replaced with dummy data first  Register To Reply

7. ## Re: Could you tell me why the second half on this formula is not working?

I Have just tried to do this, and deleted most of the content but unfortunately the file size is way to big :/  Register To Reply

8. ## Re: Could you tell me why the second half on this formula is not working?

We just need sample 10-20 rows is enough.  Register To Reply