If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=if(vlookup for non-unique values
Worksheet 1 Cash
Inv. Amt. A B 1 13300 $200 2 13300 $.01 3 12333 $2000 4 12333 $.01 WorkSheet 2 Check Hist. Inv. Amt. A B 1 13300 $200 2 12333 $2000 How do I get a value for the first Cash entry but also get a null value for second cash value. Currently using: =vlookup(A1,A$1:B$4,2,false) drag down four colomns gives me a value of: 1 $200 2 $200 this is a false value 3 $2000 4 $2000 this is a false value Please help url:http://www.ureader.com/gp/1042-1.aspx |
#2
|
|||
|
|||
=if(vlookup for non-unique values
Try something like this: (your tables are out of "whack"!)
=IF(COUNTIF(A$1:A1,A1)=1,VLOOKUP(A1,A$1:B$4,2,0)," ") -- Biff Microsoft Excel MVP "Javier Benavides" wrote in message .. . Worksheet 1 Cash Inv. Amt. A B 1 13300 $200 2 13300 $.01 3 12333 $2000 4 12333 $.01 WorkSheet 2 Check Hist. Inv. Amt. A B 1 13300 $200 2 12333 $2000 How do I get a value for the first Cash entry but also get a null value for second cash value. Currently using: =vlookup(A1,A$1:B$4,2,false) drag down four colomns gives me a value of: 1 $200 2 $200 this is a false value 3 $2000 4 $2000 this is a false value Please help url:http://www.ureader.com/gp/1042-1.aspx |
Thread Tools | |
Display Modes | |
|
|