Nested IF / VLOOKUP formula breaks when lookup value changes

[doctorblyth]

Hi all,

I have a problem with a nested IF formula i am using in the worksheet 'Output' in the attached file. The result of the formula which i am querying appears in cell 'G9'.

The lookup value for the VLOOKUP formula is a concatenation of date and advertising campaign name, the result appearing in cell G16. In its current state the nested IF formula correctly looks at worksheet 'Turn' (the IF formula knows this by looking at cell C8), and returns the Total Cost value of £165.67 in cell G9.

The problem occurs when the campaign name - in cell B4 - is replaced with another campaign name (BE - Telenet - King Kong - Oct' 13 - DR). The lookup value in cell G16 updates automatically, but the VLOOKUP fails. I expect it to return the Total Cost value of £166.67 in cell G9, but instead an error is returned. As far as i can see the VLOOKUP should match with cell A3 in the TURN worksheet, and return the corresponding Total Cost value.

If anyone can tell me why this is happening and how to overcome the problem I would really appreciate it.

Thanks
Colin

[samba_ravi]

in your vlookup formula use FALSE instead of TRUE

[doctorblyth]

Thanks very much for that. I dont quite understand how True/False makes a difference as the lookup value was 'exact' in both cases, but im pleased it now works!

Cheers,
Colin

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.