Previous Topic Next Topic

Excel

Closed
milan - May 9, 2010 at 12:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 10, 2010 at 08:03 AM
hi... i am trying to do set formula one excel file to another file but it's not working.if i set formula same file but another sheet it's worked... i am using VLOOKUP.....i have one excel file and i set VLOOKUP in new excel file...my excel even SUM/IF/COUNTIF/all of formula not worked in new excel....but if i work anothe computer it's worked
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 9, 2010 at 04:58 PM
Are both files in same directory and does the other PC has same version of excel ?
0
milan
May 10, 2010 at 07:28 AM
ye....my excel file is in desktop i mean the formula one excel file but another sheet working..but one excel file to anoher file not working eg: Old excel file is A and i oppen another excel file BOOK1....i set the Vlookup in Book1 And base i want to take from A file But it;s not working...but same case anothe computer working ( My both computer are same ,window-7, excel 2007 )=VLOOKUP(A1,A!A1:E13,2,FALSE) it's can't but =VLOOKUP(A1,Sheet2!A1:E13,2,FALSE) It's ok
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 10, 2010 at 08:03 AM
Could you zip up the two files formula and sample data that gives you that issue on some shared site like https://authentification.site and post back here the link to allow better understanding
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses