Auto Fill
 

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

Auto Fill
 

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

Auto Fill
 

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
__________________________

Auto Fill
 

Excellent!!! Thank you both very much, this was driving me bonkers, and I
don't have a lot of extra sanity to spare...it seems as if I am still having
problems since when I do that operation manually I get a different result,
and the result is the sam no matter what cell I tell it to look up.

Richard Buttrey wrote:
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

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
[quoted text clipped - 13 lines]
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?

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

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


Message posted via http://www.officekb.com

Auto Fill
 

Ah nevermind, after I had a cup of coffee and reviewed the formula
requirements, I saw the the data in the table I was searching for had to be
in the leftmost column of the table. Once I fixed that problem, it worked
like a charm!!! Thanks again to both of you.

Mark B wrote:
Excellent!!! Thank you both very much, this was driving me bonkers, and I
don't have a lot of extra sanity to spare...it seems as if I am still having
problems since when I do that operation manually I get a different result,
and the result is the sam no matter what cell I tell it to look up.

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.
[quoted text clipped - 13 lines]
Grappenhall, Cheshire, UK
__________________________


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


Message posted via http://www.officekb.com