Hi,
I think this formula solves it for you (translated, I hope it is correct).

=IF(ISERROR(VLOOKUP(A6;data;1;FALSE));0;1)

See attachment for an example.



/Bjorn

Attached Files

example1.xls (13.5 KB, 49 views)

Hi launcher,

Instead of guessing at what you mean by "a certain amount" and providing an inaccurate solution, would you please post a sample spreadsheet?

Cheers,