Looking up value in array data-set

[goldbeck09]

Hi All,

I am looking for a formula that will look-up a value from column 1 workbook1, from a data table workbook2 (no headers) 30 columns, and 250 rows.

So, I have 1 workbook with 1 column of data and I am looking up to see if that value exists on another workbook sheet.

Data to look-up for existence workbook 1:

1
12
123
1234
12345
123456

Here is what my data-set looks like workbook 2:

1 123 12345
12 1234 123456
22 3462 34672


Obviously Vlookup won't work...i've tried Index Match formulas... Not sure how else to find the existence in the 2nd workbook.

 

[Stridhan]

Guess you could you the count.if function

=IF(COUNTIF(lookuptable,your criteria)>0,"Exists","")

 

[goldbeck09]

I definitely did not consider the avenue of countif...it works though.. Thank you very much. I was making this task way too complex.

 

[Stridhan]

You're welcome