Thank for your help Mr. Phillips. I appreciate you taking the time to help
me with my problem.

Have a great weekend !
-scott

"Bob Phillips" wrote:



"scott" wrote in message
...
Just trying to understand how Excel thinks when putting a formula
together.
I had another question about why the MATCH function was used twice.

Did you use the MATCH function in conjunction with ISNUMBER, to check to
ensure it returns a number ?


Yes. MATCH returns the index within the lookup set if it finds the value, or
#N/A if it doesn't. ISNUMBER is a simple way to test if the MATCH was
successful or not.



IF(ISNUMBER(MATCH(A3,Sheet2!$A:$A,0)),INDEX(Sheet2 !$H:$H,MATCH(A3,Sheet2!$A:$A,0)),"")

The way I'm reading the formula....

IF (it's a number) THEN (use the value in column H) that equals (the row
returned from the MATCH function). I'm guessing the double quotations at
the
end mean use its value or something.

Is that kind of how you'd read it ?


More or less. If the MATCH is successful, if passes that row index to the
INDEX function to get the corresponding value in H. If it fails,the double
quotes are used to retun an empty value, so it doesn't show #N/A in the
cell.


P.S. The formula you wrote did exactly what I was trying figure out. I
just want to make sure I understand how you came up with it.


No I get it, it's the only way to get better.