lookup function problem

[PALUCA1982]

i need help with the following formulas,i have tried both and neither work. can anyone see something wrong that i don't? is this not possible? The goal is to type a number in a cell (G4) on a worksheet, and then look it up in a different work sheets (JANUARY THROUGH MARCH) in a different workbook,(NEW DAILY SUMMARY.xls) Once found, import the value of the cell next to were the number was found. Can anyone help please?

=LOOKUP(G4,'[NEW DAILY SUMMARY.xls]JANUARY'!$I$3:'[NEW DAILY SUMMARY.xls]MARCH'!$I$33,'[NEW DAILY SUMMARY.xls]JANUARY'!$J$3:'[NEW DAILY SUMMARY.xls]MARCH'!$J$33)

OR

=LOOKUP(G4,'[NEW DAILY SUMMARY.xls]JANUARY:MARCH'!$I$3:$I$33,'[NEW DAILY SUMMARY.xls]JANUARY:MARCH'!$J$3:$J$33)

[PALUCA1982]

i need help with the following formulas,i have tried both and neither work. can anyone see something wrong that i don't? is this not possible? The goal is to type a number in a cell (G4) on a worksheet, and then look it up in a different work sheets (JANUARY THROUGH MARCH) in a different workbook,(NEW DAILY SUMMARY.xls) Once found, import the value of the cell next to were the number was found. Can anyone help please?

=LOOKUP(G4,'[NEW DAILY SUMMARY.xls]JANUARY'!$I$3:'[NEW DAILY SUMMARY.xls]MARCH'!$I$33,'[NEW DAILY SUMMARY.xls]JANUARY'!$J$3:'[NEW DAILY SUMMARY.xls]MARCH'!$J$33)

OR

=LOOKUP(G4,'[NEW DAILY SUMMARY.xls]JANUARY:MARCH'!$I$3:$I$33,'[NEW DAILY SUMMARY.xls]JANUARY:MARCH'!$J$3:$J$33)

[shg]

Excel won't do that directly; you could use a more complicated formula,

=if(iserror(JanLookup), if(iserror(FebLookup), if(iserror(Marlookup), "", MarLookup), FebLookup), JanLookup)

... or use the VBA solution at http://www.ozgrid.com/VBA/VlookupAllSheets.htm

[shg]

Threads merged.

PALUCA, please don't post the same thread in two forums.