Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Lookup with If
Hello, I have a table that I do lookups on in a worksheet that seems to not work as I expected. I added another column of source table data that I want to use to do a conditional check, i.e. if value in cell = Y then proceed and read the table data and do a calculation. I can't seem to get the check to work. I tried to make it an "AND" so that two conditions would have to be met, but that didn't work. Here's my formula, before and after I added the additional column of data and check. Befo =IF(D53="Synch",(VLOOKUP(B53,PublisherTable!$A:$V, 4,FALSE)),IF(D53="Print",(VLOOKUP(B53,PublisherTab le!$A:$V,13,FALSE)),IF(D53="Mech",(VLOOKUP(B53,Pub lisherTable!$A:$V,10,FALSE)),IF(D53="Perf",(VLOOKU P(B53,PublisherTable!$A:$V,7,FALSE)),IF(D53="Maste r",(VLOOKUP(B53,PublisherTable!$A:$V,7,FALSE)),IF( D53="Services",0%,0%)))))) After: =IF(D59="Synch" & K59="NO",(VLOOKUP(B59,PublisherTable!$A:$V,4,FALSE )),IF(D59="Print"& K59="NO",(VLOOKUP(B59,PublisherTable!$A:$V,13,FALS E)),IF(D59="Mech"& K59="NO",(VLOOKUP(B59,PublisherTable!$A:$V,10,FALS E)),IF(D59="Perf"& K59="NO",(VLOOKUP(B59,PublisherTable!$A:$V,7,FALSE )),IF(D59="Master"& K59="NO",(VLOOKUP(B59,PublisherTable!$A:$V,7,FALSE )),IF(D59="Services"& K59="NO",0%,0%)))))) The after does not appear to work, if I change the NO to YES, and there is a match, it doesn't work. Any help appreciated. Thanks, Victor -- victorcab ------------------------------------------------------------------------ victorcab's Profile: http://www.excelforum.com/member.php...o&userid=13675 View this thread: http://www.excelforum.com/showthread...hreadid=400180 |
#2
|
|||
|
|||
Your use of AND is incorrect Change your conditional check to: =IF(AND(D59="Synch",K59="No"),now your VLOOKUP,etc,etc -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=400180 |
#3
|
|||
|
|||
Have another go using the if and formula =IF(AND(D59="Synch",K59="NO"),VLOOKUP(B59,Publishe rTable!$A:$V,4,FALSE),IF(AND(D59="Print",K59="No") ,VLOOKUP(B59,PublisherTable!$A:$V,13,FALSE),IF.... .. Take care where you put the () brackets -- bill k ------------------------------------------------------------------------ bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821 View this thread: http://www.excelforum.com/showthread...hreadid=400180 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
how to use lookup a value by date for criteria in Excel sheet | Excel Worksheet Functions | |||
Lookup Access data in Excel | Excel Worksheet Functions | |||
HELP! Excel Lookup formula | Excel Worksheet Functions |