Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help to resove this problem.
I have a workbook with 3 sheets.
Sheet 1 is named (D), Sheet 2 (Settings) and Sheet 3 (Countries). In sheet (D), I have all the countries that I require ( 39 countries) from cell A2 to A40 and in cell A1 I have the heading ENGLISH. In sheet (Countries) I have the names of the 39 countries from cell E7 to E45. In cell E7 I have the country name ENGLAND and when I click on this cell, it appears =AF8 in the formula bar, where when I click on cell AF8 it appears =index(D,38,lang) in the formula bar. The problem is that I am trying to put the country name ENGLAND in cell W1 by clicking on this cell and write =AF8 in the formula bar and click ENTER. The cell W1 remains blank. Just to tell you that the country name ENGLAND is in cell A38 in sheet (D). Will you please help me solve this problem? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
'If' problem | Excel Worksheet Functions | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Max Value Problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |