I am trying to check one column of data vs. another column in a separate
worksheet. If it equals, then I want it to return another column's data in
the 2nd worksheet.

"NCSUBoz" wrote:
I am trying to check one column of data vs. another column in a separate
worksheet. If it equals, then I want it to return another column's data in
the 2nd worksheet.

INDEX/MATCH would be one good way to do it ..

You can match on any column, and return any other column (to the left or
right of the matching col) via the INDEX part of it.

Eg to exact match a lookup value in Sheet1's A2
against Sheet2's col Z & return from Sheet2's col K

In Sheet1,
you could put in B2:
=INDEX(Sheet2!K:K,MATCH(A2,Sheet2!Z:Z,0))
B2 could be copied down to return correspondingly for other lookup values in
A3, A4, etc.

And if you need an error trap to return neat looking "blanks", viz. "" for
any unmatched cases (instead of ugly #N/As), you could use this in B2:
=IF(ISNA(MATCH(A2,Sheet2!Z:Z,0)),"",INDEX(Sheet2!K :K,MATCH(A2,Sheet2!Z:Z,0)))

Try Debra Dalgleish's nice coverage on INDEX/MATCH at her page:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---