Hi,
I am using vlookup formula in Excel to retrieve data from two sheets.
(since my data is more than 65536 rows I am dividing it to two
different sheets).
My original data comes as a text file export from other software.
Recently I've set up an ODBC text driver to connect to that text file
and it works, but it comes only to one worksheet. How to split it to
two sheets?
My second question is: Is that possible to write custom function in VB
to retrieve data right from ODBC connection, i.e. some replacement to
undermentioned formula.
I've recorded a macro during retrieval from ODBC, but it downloads
data and puts it on the all rows. I need to do a query for each cell
separately, like my original vlookup formula.

My actual lookup formula looks like this
=IF(ISERROR(VLOOKUP(A2,first_sheet,1,FALSE)),VLOOK UP(A2,second_sheet,2,FALSE),VLOOKUP(A2,first_sheet ,2,FALSE))


Thanks for your help.