VLOOKUP Running off a data list

[officeworker]

I have encountered a problem regarding a formula I have.

I have a nested if statement running off a data list (from a dat
validation drop down menu) which contains VLOOKUPS.

When I use the 'Evaluate Formula' tool the statement is able to retur
the correct values depending on the different criteria selected in th
data validation drop down menu. However in the worksheet it keep
returning the same value!

The formula is as follows:

=IF(C25="1st Audit",VLOOKUP(C4,Audits!D:I,4,0),IF(C25="2n
Audit",VLOOKUP(C4,Audits!D:I,5,0),IF(C25="Annual",VLOOKUP(C4,Audits!D:I,6,0))))

P.S. C4 = A unique store name


Any ideas why when I select the different options from the drop dow
menu 1st Audit or 2nd Audit or Annual it returns the same value?


Is this a problem anyone has come across before working with VLOOKUP
running off a list that you change?

Any help would be appreciated. I am completely stumped

 

[Guest]

which of the responses does it give? I assume it is probably the one for
"Annual".
check : in empty cells enter
=C5="1st Audit"
=C5="2nd Audit"
=C5="Annul"
see if you get appropriate "true"s as you select the different options.
you may need to use Trim(C5)