Previous Topic Next Topic

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.
Related:

1 response

Answer 1 / 1
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses