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,