References
 

I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.


I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.

References
 

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

wrote:

I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.

I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.

--

Dave Peterson

References
 

Vlookup finds the row that matches using the leftmost column of the lookup
range to look in, then returns what is in the cell in the same row in the
specified column (argument 3). The 4th argument determines if it does an
exact match or not. If it is false, it does an exact match. If True, it
requires that the leftmost column be sorted. See help for details. It
doesn't identify a row and column intersection.

--
Regards,
Tom Ogilvy


" wrote:

I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.


I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.

References
 

On Jul 4, 9:36 pm, Tom Ogilvy
wrote:
Vlookup finds the row that matches using the leftmost column of the lookup
range to look in, then returns what is in the cell in the same row in the
specified column (argument 3). The 4th argument determines if it does an
exact match or not. If it is false, it does an exact match. If True, it
requires that the leftmost column be sorted. See help for details. It
doesn't identify a row and column intersection.

--
Regards,
Tom Ogilvy



" wrote:
I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.

I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.- Hide quoted text -

- Show quoted text -

If you could offer anymore suggestions I would be most appreciative.
Well here is an example of what I want to do


Workbook 1
Column A B c
Row 1 Unique ID(34343) State(NY) Zip(21212)
..
..
..
Row 100 Unique ID(84947) State(TX) Zip(84849)


WORKBOOK 2
*Note - I have, for the most part, the same Unique ID's in this
workbook(II), but non of the states and zip codes associated with them
are in this workbook(II). Therefore i want to find a formula that
finds the unique id in workbook II and returns the state and zip
associated with that unique Id in book one to book two. Otherwise i
have to cut and past 15,000s rows of data, which is a week of wasted
time.

Workbook 2
Column A B c
Row 1 Unique ID(34343) "Empty" "Empty"
..
Row 3 *New ID(45878) "Empty" "Empty"
..
..
Row 100 Unique ID(84947) "Empty" "Empty"

References
 

On Jul 4, 9:36 pm, Tom Ogilvy
wrote:
Vlookup finds the row that matches using the leftmost column of the lookup
range to look in, then returns what is in the cell in the same row in the
specified column (argument 3). The 4th argument determines if it does an
exact match or not. If it is false, it does an exact match. If True, it
requires that the leftmost column be sorted. See help for details. It
doesn't identify a row and column intersection.

--
Regards,
Tom Ogilvy



" wrote:
I am seeking to match rows of one excel workbook with a another
booklet.

I have tried v lookups but have had no success with these bc the
vlookup only identifies the row and the column intersection and not
whats in that cell.

I want a solution that will read whats in a cell. I.e. Unique id
34343. Then find the unique ID 34343 in another cell of another
workbook and return specific data in the same row of the unique Id.

I extremely desperate for a solution. if you need more explanation i
can provide this, moreover, for anyone who is seeking a challenge this
may be for you.

Thank you.- Hide quoted text -

- Show quoted text -

If you could offer anymore suggestions I would be most appreciative.
Well here is an example of what I want to do

Workbook 1
Column A B c
Row 1 Unique ID(34343) State(NY) Zip(21212)
..
..
..
Row 100 Unique ID(84947) State(TX) Zip(84849)


WORKBOOK 2
*Note - I have, for the most part, the same Unique ID's in this
workbook(II), but non of the states and zip codes associated with
them
are in this workbook(II). Therefore i want to find a formula that
finds the unique id in workbook II and returns the state and zip
associated with that unique Id in book one to book two. Otherwise i
have to cut and past 15,000s rows of data, which is a week of wasted
time.


Workbook 2
Column A B c
Row 1 Unique ID(34343) "Empty" "Empty"
..
Row 3 *New ID(45878) "Empty" "Empty"
..
..
Row 100 Unique ID(84947) "Empty" "Empty"