Posted to microsoft.public.excel.worksheet.functions
|
|
find match formula
This one works. Thanks!
--
Thank You!
"Bernard Liengme" wrote:
Have a look at VLOOKUP in Help then come back for more.
=VLOOKUP(A1,$C$1:$D$D49,2,FALSE) will return the $50,000 value
=VLOOKUP(A2,$C$1:$D$D49,2,FALSE) will return #N/A since there is no match
=VLOOKUP(A3 ,$C$1:$D$D49,2,FALSE) will return the $200,000 value
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"maijiuli" wrote in message
...
Hello,
I am looking for a formula that will find matching records and also do a
caluculation.
I have 4 columns set up. A, B, C and D.
Column A is Social Security Number
Column B is Election Amount #1
Column C is Social Security Number
Column D is Election Amount #2
An example:
Col A Col B Col C Col D
123456789 $100,000 123456789 $50,000
111111111 $250,000 222222222 $200,000
222222222 $300,000
Column A & B have 69 rows and should remain with each other. Meaning if
one
row moves the other row should also. Column C & D have 33 rows.
I want to find and somehow line up all the matching records Col A = Col C
so
I can easily look and figure out which elections will be allowed and which
ones will not. The rule is the second election amount cannot be more than
50% of the first election amount of the same member.
If there is an easier way please let me know.
Thank you very much,
--
Thank You!
|