Consolidate text

I need to consolidate two different worksheets that contain text. One
worksheet contains the following:

Row A -
Row B - alphanumeric identifier
Row C&D - numbers

The second worksheet contains the following:

Row A - name
Row B - alphanumeric identifier

I need to pull the name from the second worksheet that matches the
alphanumeric identifier in the first worksheet. Any ideas?

Thanks,

You mean columns A, B, C&D, right?

Put this in the cell that should return the name (A2???):
=index(sheet2!a:a,match(b2,sheet2!b:b,0))

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

EXCEL101 wrote:
>
> I need to consolidate two different worksheets that contain text. One
> worksheet contains the following:
>
> Row A -
> Row B - alphanumeric identifier
> Row C&D - numbers
>
> The second worksheet contains the following:
>
> Row A - name
> Row B - alphanumeric identifier
>
> I need to pull the name from the second worksheet that matches the
> alphanumeric identifier in the first worksheet. Any ideas?
>
> Thanks,

--

Dave Peterson

Thank you that was exactly what I needed!

"Dave Peterson" wrote:

> You mean columns A, B, C&D, right?
>
> Put this in the cell that should return the name (A2???):
> =index(sheet2!a:a,match(b2,sheet2!b:b,0))
>
> You may want to read Debra Dalgleish's notes:
> http://www.contextures.com/xlFunctions02.html (for =vlookup())
> and
> http://www.contextures.com/xlFunctions03.html (for =index(match()))
>
> EXCEL101 wrote:
> >
> > I need to consolidate two different worksheets that contain text. One
> > worksheet contains the following:
> >
> > Row A -
> > Row B - alphanumeric identifier
> > Row C&D - numbers
> >
> > The second worksheet contains the following:
> >
> > Row A - name
> > Row B - alphanumeric identifier
> >
> > I need to pull the name from the second worksheet that matches the
> > alphanumeric identifier in the first worksheet. Any ideas?
> >
> > Thanks,
>
> --
>
> Dave Peterson
>