I am importing data from a web page into worksheet 1, worksheet 2 and worksheet 3. Worksheet 4, B3:B32 uses INDEX MATCH functions to bring forward values in each cell based on data from worksheet 1. Worksheet 4, C3:C32 uses INDEX MATCH functions to bring forward values in each cell based on data from worksheet 2. Worksheet 4, D3:D32 uses INDEX MATCH functions to bring forward values in each cell based on data from worksheet 3. Worksheet 4, E3:E32 uses SUM functions to add B3, C3 and D3, etc., for each cell [i.e. E3:E32]. Worksheet 4, F3:F32 uses RANK functions to order each each cell. THE PROBLEM IS: When the external data is refreshed the INDEX MATCH functions used in worksheet 4 are not being recalucated and, instead, are showing the value of "0" in each B, C, D and E cell with the value of "1" in each F cell. Any help would be very much appreciated.
Bookmarks