Thread: Using Vlookup & IF together
View Single Post
 
Old 01-14-2010, 01:43 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
  
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default
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
File Type: xls example1.xls (13.5 KB, 49 views)
Reply With Quote