Excel vlook up help [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello Chandan

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

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!