Need Help Linking Spreadsheets

[JG]

I have two spreadsheets (A and B) that have a common key
(lastname,firstname). I want to lookup in spreadsheet 'B' all the names
listed in 'A', select the value that is one cell to left of the name in
'B' and stick that value in a cell in spreadsheet 'A' in the same row as
the name looked up. Is this possible?

[No1]

It would be very easy to do using vlookup if the names were
in the first column and the lookup data were to the right.
I'm sure someone else will fill in the details to achieve
your goal. I think Alan Beban has a lookup to left on his
web page, do a search for him on the web and look for it.

On Sun, 05 Sep 1999 23:49:55 -0700, JG <gebh...@erinet.com>
wrote:

:I have two spreadsheets (A and B) that have a common key

[Patrick Molloy]

using VLOOKUP is the most common solution. However, in your lookup
table, the lookup values need to be in the first column, and sorted,
with the rest of the data in columns to the right.

[Leonard E. Meads]

Unless you modify your data structure, VLOOKUP will not work as No1 and
Patrick have indicated.

To maintain the current structure, use INDEX(MATCH()).

For example, to use name in SheetA!B1 as the look_up value for the
inspection of data in range SheetB!B1:B10 and return the associated value
from SheetB!A1:A10, use in SheetA the formula
=INDEX(SheetB!A1:A10,MATCH(SheetA!B1,SheetB!B1:B10,0))

You fail to say which version of XL you're using (always disclose this
because what works in one version may not in another), so I'm assuming XL97
SR2 US.

I noticed that you posted your article via a Usenet server. IMO, for best
results when using the MS public NGs, participants should connect directly
to the MS public server <msnews.microsoft.com> rather than via a Usenet
server or web-based news service.

--
Len Meads
mea...@sprynet.com

************************************************************
For best connection to MS public NGs, connect
directly to MS public server <msnews.microsoft.com>
************************************************************

JG <gebh...@erinet.com> wrote in article <37D36413...@erinet.com>...