I would appreciate help on the following:-
I have 2 excel sheets both set out as Tables (Table 2 and Table 3). Table 2 has 4 columns A B C D and Table 3 has 2 columns B and C.
The data in column A and C of Table 2 is static. The data in columns B and D varies through in on another cell in another Sheet 3. The data in column B of Table 3 is static and in column C of Table 3 the data varies according to the input on the cell mentioned above in Sheet 3.
So, Column A in Table 2 is the same data as in column C of Table 3 but column C is set out in a different order. Column D in Table 2 is the same data as in column B of Table 3 but is set out in a different order. What I would like is a formula that would automatically update Column C in Table 3 when the data in the cell on Sheet 3 is altered. I think this can be done by INDEX and MATCH. But do not know how.
I hope I have set out the problem clearly enough.
Thank you in anticipation of your help.
If you were to post what you have, we could help. We don't provide turn key solutions. Post back if you get stuck ON YOUR OWN code, and we can help.
I have poured time and effort into a solution, only to have the OP say "it doesn't work!" Then, find out that they left out 50% of the problem!
It's kind of fun to do the impossible! -Walter Elias Disney
Thank you for your response. I have tried accessing speedyshare.com but am unable to get to it. All sorts of interference from other websites is coming so perhaps there is a virus on it? If you know of a more secure site please let me know and I will upload the data there. Thank you.
Thank you vcoolio. Your help is appreciated. Data now uploaded to GE.TT under ' INDEX and Match'- BAM Travelers(all)2. I hope this is sufficient info.
A few words of explanation of the Data which has been uploaded . Columns A & C in Table 2 are fixed. Column B is variable. In Table 3 Columns A and B are fixed with column C being variable. Cell K1on Table 2 is a variable number (range 12 to 31) which controls both these variable columns. I wish to have a formula which will automatically update Column C (table 3) when the number in cell K1 is altered. If you require further information please let me know.
I look forward to the response from Mazzaropi.
My understanding is that both vcoolio and Mazzaropi suggested that I upload my file to ge.tt . This is what I did. I do not have a formula(code). This is what I am looking for help on. I have previously set out what I am trying to do and would appreciate help. After I had posted the file to ge.tt you yourself said "looks like things are going well, thanks to Mazzaropi and vcoolio".
As you suggest, I am having "FUN"!