Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

VLOOKUP LEFT VS RIGHT

4 views
Skip to first unread message

Jerry

unread,
Sep 6, 2007, 11:59:54 PM9/6/07
to
Can I compose a VLOOKUP formula that looks left instead of right. I have
data in C10 and want to go left 4 cells and get that data. Can this be
done. I don't think so but I'm no expert in VLOOKUP.

T. Valko

unread,
Sep 7, 2007, 12:21:51 AM9/7/07
to
VLOOKUP works from left to right.

>I have data in C10 and want to go left 4 cells and get that data

4 cells left of C10? There aren't 4 columns to the left of column C.

You can use something like this:

=INDEX(range,MATCH(lookup_value,lookup_array,0))


--
Biff
Microsoft Excel MVP


"Jerry" <Je...@nospam.com> wrote in message
news:Xns99A4218835Fjo...@140.99.99.130...

Alan Beban

unread,
Sep 7, 2007, 10:40:20 AM9/7/07
to
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, you might
want to consider the VLookupLeft function.

Alan Beban

0 new messages