Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why dont this work? and copy functions
=IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0)),"",G4)
I got this function from Sean Timmons, but can not get it working, can anyone tell me why? It returns with #name? This is to put in a column D4 in sheet 'total', but also need to change the '507.xls* to '508.xls' for the next sheet, the next is E4 that need '508.xls'. The columns has 357 rows on some rows are not used for better presantation purposes, how to cupy the "new" formula to all row in a column? Hope anyone understand the question Have a nice day :) -- Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why dont this work? and copy functions
Just hazarding a guess as to what you're trying to do here ..
Perhaps something like this in D4: =IF(ISNA(VLOOKUP($A4,INDIRECT("'50"&COLUMNS($A:A)+ 6&".xls'!A:A"),0)),"",G4) which presumes you have a sheet named: 507.xls. And when you copy D4 to E4, it'll then lookup A4 vs col A in the sheet named: 508.xls, and return H4 if there's no match found. Adapt to suit. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:61 xdemechanik --- "Rockbear" wrote: =IF(ISNA(VLOOKUP(A4,'507.xls'!$A:$A,1,0)),"",G4) I got this function from Sean Timmons, but can not get it working, can anyone tell me why? It returns with #name? This is to put in a column D4 in sheet 'total', but also need to change the '507.xls* to '508.xls' for the next sheet, the next is E4 that need '508.xls'. The columns has 357 rows on some rows are not used for better presantation purposes, how to cupy the "new" formula to all row in a column? Hope anyone understand the question |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Buttons dont work after I put them in the toolbar | New Users to Excel | |||
buttons dont seem to work after I put them into the toolbar | Excel Discussion (Misc queries) | |||
Copy paste in excel dont work properly | Excel Discussion (Misc queries) | |||
Formulas dont work | Excel Discussion (Misc queries) | |||
help NEEDED URGENTLY (I HAVE TRIED SOME SUGGESTIONS BUT THEY DONT WORK UNLESS I AM DOING THEM WRONG | Excel Worksheet Functions |