|
|
#4
08-17-2012, 12:15 AM
|
|||
|
|||
Not sure what you mean, this will give you a count of the values! Need some clarification on what you are trying to achieve!
=IF(COUNTIF($A$1:A2,$A2)=1,VLOOKUP($A2,VBAP!$A:$C, 3,FALSE)*COUNTIF($A$2:$A$34,$A2),"") 
|
| Tags |
| vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Using IF and VLOOKUP together
|
Becki | Excel | 2 | 04-06-2012 05:32 PM |
| something like VLOOKUP | hanvyj | Excel | 4 | 03-13-2012 09:03 AM |
|
Vlookup
|
ibrahimaa | Excel | 5 | 03-04-2012 11:24 AM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode