Excel

Closed
milan - May 9, 2010 at 12:37 AM
rizvisa1
Posts
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 9, 2010 at 04:58 PM
Are both files in same directory and does the other PC has same version of excel ?
0
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
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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