| 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 |
| 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 | |||
Threaded Mode
