Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Running off a data list
I have encountered a problem regarding a formula I have. I have a nested if statement running off a data list (from a data validation drop down menu) which contains VLOOKUPS. When I use the 'Evaluate Formula' tool the statement is able to return the correct values depending on the different criteria selected in the data validation drop down menu. However in the worksheet it keeps returning the same value! The formula is as follows: =IF(C25="1st Audit",VLOOKUP(C4,Audits!D:I,4,0),IF(C25="2nd 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 down menu 1st Audit or 2nd Audit or Annual it returns the same value? Is this a problem anyone has come across before working with VLOOKUPS running off a list that you change? Any help would be appreciated. I am completely stumped! -- officeworker ------------------------------------------------------------------------ officeworker's Profile: http://www.excelforum.com/member.php...o&userid=36021 View this thread: http://www.excelforum.com/showthread...hreadid=559852 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Running off a data list
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) "officeworker" wrote: I have encountered a problem regarding a formula I have. I have a nested if statement running off a data list (from a data validation drop down menu) which contains VLOOKUPS. When I use the 'Evaluate Formula' tool the statement is able to return the correct values depending on the different criteria selected in the data validation drop down menu. However in the worksheet it keeps returning the same value! The formula is as follows: =IF(C25="1st Audit",VLOOKUP(C4,Audits!D:I,4,0),IF(C25="2nd 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 down menu 1st Audit or 2nd Audit or Annual it returns the same value? Is this a problem anyone has come across before working with VLOOKUPS running off a list that you change? Any help would be appreciated. I am completely stumped! -- officeworker ------------------------------------------------------------------------ officeworker's Profile: http://www.excelforum.com/member.php...o&userid=36021 View this thread: http://www.excelforum.com/showthread...hreadid=559852 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
VLOOKUP Function using Data Ranges. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |