Carpiem
06-17-2006, 07:44 AM
Good Morning,
I see the Find Method being used rather than:
VLOOKUP(C3,rngNetIncome,MATCH(C3,rngHeaders,0),0)
or
INDEX(NetIncome,MATCH($C3,INDEX(NetIncome,,1),0),MATCH("P2Deduction",INDEX(NetIncome,1,),0))
Is it as flexible to use? Why is it used instead of VLookup or IndexMatch?:dunno
Would someone please briefly explain how the Find Method is used to look at a column in a table and return values found. How do you move to a different column?
All responses much appreciated.
Carpiem
I see the Find Method being used rather than:
VLOOKUP(C3,rngNetIncome,MATCH(C3,rngHeaders,0),0)
or
INDEX(NetIncome,MATCH($C3,INDEX(NetIncome,,1),0),MATCH("P2Deduction",INDEX(NetIncome,1,),0))
Is it as flexible to use? Why is it used instead of VLookup or IndexMatch?:dunno
Would someone please briefly explain how the Find Method is used to look at a column in a table and return values found. How do you move to a different column?
All responses much appreciated.
Carpiem