Excel vlook up help

Closed
chandan - Jul 22, 2009 at 09:30 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 23, 2009 at 12:00 AM
Hello,
i have a excel sheet where i have lot of columns
in sheet 1 from a1-a100 there are different numbers say a1-0101, a2-103 so on
on sheet 2 there is a column where there is 30 numbers say a1-0103, a2-104,a3-103 etc
i want a solution where i can put a blank column in sheet 1 say b1-b100 and there all the matching numbers in sheet1 and sheet 2 will have some value like 1 or x.

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 23, 2009 at 12:00 AM
Hello Chandan

try =if(countif(range,criteria)>0,1,"X")
1