software

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

Row A -
Row B - alphanumeric identifier
Row Camp;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, Camp;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:
www.contextures.com/xlFunctions02.html (for =vlookup())
and
www.contextures.com/xlFunctions03.html (for =index(match()))

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

--

Dave Peterson

Thank you that was exactly what I needed!

quot;Dave Petersonquot; wrote:

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