software

Maybe a stupid question .. but what exactly is the difference in function?

VLOOKUP allows you to find an entry in a list and return a value that
is a given number of columns away from that entry. This can be a text
string or numeric value.

MATCH returns an integer number of the row within a range that matches
the entry in question.

You can next a MATCH function within an INDEX function and perform an
operation very similar to a VLOOKUP, because the INDEX function works
on a grid-type array of data.Thanks Dave. That is what I thought. I use Index, match and offset to
return values outside of the specified array, where vlookup seems limited eg:

=OFFSET(INDEX(samplearray,MATCH(C10,col,0),MATCH(C 11,row,0)),-2,-3)

but thought I was missing something!
quot;Dave Oquot; wrote:

gt; VLOOKUP allows you to find an entry in a list and return a value that
gt; is a given number of columns away from that entry. This can be a text
gt; string or numeric value.
gt;
gt; MATCH returns an integer number of the row within a range that matches
gt; the entry in question.
gt;
gt; You can next a MATCH function within an INDEX function and perform an
gt; operation very similar to a VLOOKUP, because the INDEX function works
gt; on a grid-type array of data.
gt;
gt;

VLOOKUP looks in an mxn array, and returns the value in the row that the
lookup value is in, offset by the column offset number.

MATCH looks in either an mx1 or 1xn array, and just returns the index of the
matched item within the lookup range.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Newbiequot; gt; wrote in message
...
gt; Maybe a stupid question .. but what exactly is the difference in function?

An other important difference between vlookup and indexamp;match is that
when using vlookup the look-up value needs to be in the leftmost
column.

Indexamp;match doe not require that.

ie vlookup:

Col A Col B Col C
1 A HI
2 B Bye
3 C Yes
4 D No

If your lookup value was in Col B (lets say quot;Bquot;), you could not look up
values form Col A (quot;2quot;)

You could do it with index amp; match though.--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: www.excelforum.com/member.php...oamp;userid=33279
View this thread: www.excelforum.com/showthread...hreadid=542246