Vlookup

[gj&wxb]

<table border="0" cellpadding="0" cellspacing="0" height="300" width="489"><col width="69"><tr height="17"> <td style="height:12.9pt;width:52pt" height="17" width="69">As data in sheet1 has exceeded row 65536, therefore I have to create sheet2 for new data. Is there any method to vlookup data from both sheet1 & sheet2 ?</td> </tr></table>

 

[sheetspread]

Use an IF/ISERROR formula

 

[cgcamal]

Exactly as mentioned by sheetspread, something like:

Cell Formulas
Range	Formula
A1	=IFERROR(VLOOKUP("Value_To_LookUp",Sheet1!A:B,2,FALSE),VLOOKUP("Value_To_LookUp",Sheet2!A:B,2,FALSE))

Hope this helps.

Regards.

 

[Aladin Akyurek]

<TABLE border=0 cellSpacing=0 cellPadding=0 width=489 height=300><COLGROUP><COL width=69><TBODY><TR height=17><TD style="WIDTH: 52pt; HEIGHT: 12.9pt" height=17 width=69>As data in sheet1 has exceeded row 65536, therefore I have to create sheet2 for new data. Is there any method to vlookup data from both sheet1 & sheet2 ?</TD></TR></TBODY></TABLE>

Looks like you are on Excel 2003 or an earlier system. If so, try something like:

=IF(ISNUMBER(MATCH(LookupValue,Sheet1!A:A,0)),INDEX(Sheet1!B:B,
    MATCH(LookupValue,Sheet1!A:A,0)),INDEX(Sheet2!B:B,
      MATCH(LookupValue,Sheet2!A:A,0)))

for unsorted data.