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