Thread: Help with VLOOKUP formula
View Single Post
 
Old 08-17-2012, 12:15 AM
Kevin@Radstock Kevin@Radstock is offline Windows 7 32bit Office 2010 32bit
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
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),"")
Reply With Quote