IF Function on a range of Data
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. |
IF Function on a range of Data
"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 --- |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com