# 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!!

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))))

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?

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))

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.

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

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 :/

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1