using Vlookup to identify > 1 values by ID #

[Damian37]

Hello Everyone,
I'm trying to pull in information from one spreadsheet to another by using Vlookup, however, I only want to bring back a true/false value if the record has a value > 1. Essentially I'm tracking certain types of transactions, and I only want to identify instances where the # of transactions is > 1. I'm using a COUNTA formula to identify instances where the rep has performed a transaction. I'm only interested in transactions that are > 1.

Ex.
ID# Formula Value
NNN 1
DDD 2
WWW 0
TTT 3

I then have a summary file in which I only have the ID #. I want to perform a vlookup to bring back only records in which the Formula Value is > 1. I was hoping someone has come across this issue before, and can tell me whether a Vlookup formula is what I should be using, or if I should use a different formula to get the results I need. All help is greatly appreciated. Thanks

Damian

 

[AliGW]

What does your example data represent? Is it the result you are looking for? What does the lookup data look like?

 

[godsaaint]

Try the formula below, "Sheet2" being the name of the sheet you are trying to pull info from, and make sure to change $B$2:$B$5 and $A$2:$A$5 to the real ranges.

=INDEX(Sheet2!$B$2:$B$5,MATCH(A2,Sheet2!$A$2:$A$5,0))>1