|
|
#3
11-17-2010, 01:53 PM
|
|||
|
|||
Thought my original lookup was a bit top heavy and it later occurred to me that half of it isn't needed. Try this one in H6 instead.
=IF(ISNA(VLOOKUP(F6,[PickList.xls]Pick!$D$2:$G$9,1,FALSE))=TRUE,0,VLOOKUP(F6,[PickList.xls]Pick!$D$2:$G$9,4,FALSE)) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
| Vlookup Examples Please ????? | AmrMahmoud1982 | Excel | 2 | 10-10-2010 06:31 PM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
 Is this possible using the Vlookup or any other function?
|
Delson | Excel | 4 | 02-08-2010 01:27 PM |
| vlookup question | Tony G | Excel | 9 | 03-28-2009 11:16 PM |
Windows XP 
Office 2007
Threaded Mode