PDA

View Full Version : Solved: Find Method - Why & How?



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

Norie
06-17-2006, 08:14 AM
Carpiem

Where are you seeing Find used?

Carpiem
06-17-2006, 03:10 PM
Hi Norie,

I did a search of the threads here and one that relates to my question was The .FIND Method ... Arrrrrgh! (Dec 23 2005) by Cyberdude.

In response Johnske contributed a file that touches on what I am interested in.

Looking up part numbers and returning values from other sheets when matches are found.

Don't think I have explained this very well. Please disregard this post.

I must look more closely at Johnske's examples before firing off questions.

Many thanks,

Carpiem