I have 2 seperate excel files
in one file 7 columns ( Data in Text format varying from 10 to 15 digit)
in another file 5 columns (Data In Numeric/ number format varying from 10 to
15 digit)
Iwant to find the numbers of the first file col. B in other columns as well
as in another files columns too.
i.e. if in col. B if figure 1234567890 in raw 1 and 2345678901..... whether
the same number is available in other columns of the same file as well as
another file, and if available then which number ? no. in raw 1 or no. in raw
2 ?

can i get the result in a seperate worksheet or a seperate column. Many time
i have data more than 60000 lines in one column only. can i use if match
function?
in if match function it takes lots of time to varify the data and i have to
wait even i have 1GB RAM.

please help