The only thing I'd add is a ",False" in the formula to ensure the
vlookup finds an exact match rather than the nearest match.

i.e. =VLOOKUP(A1,MyNamedRange,2,False)


Rgds

On Fri, 12 Aug 2005 12:09:17 -0700, "Eric White"
wrote:

A non-VBA way would be to use VLOOKUP. Assign a name to the entire table on
Sheet 2, then use VLOOKUP w/ that named range and appropriate colum offsets
to return the data. e.g., Sheet 1, A2's formula would be.

=VLOOKUP(A1,MyNamedRange,2)

The last value ("2") in the formula tells Excel which column in MyNamedRange
you want data returned from.

"Mark B via OfficeKB.com" wrote:

I have a workbook with a series of ID numbers in one column on the first tab,
and on tab two is a spreadsheet with circuit ID's (not necessarily the same
ones), a date that circuit was connected, customer name and address, etc- all
the data is in separate columns on the second tab.

What I want to do is find the Circuit ID from the first sheet within the
second sheet, and if it exists, copy the connect date and customer name onto
the first sheet in separate columns. Can one of you guys help pleaase?

--
Mark Brindamour
mtbrindamour[AT]hotmail[dot]com


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200508/1


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________