koala
02-19-2006, 01:16 AM
Hi Forum,
I am not sure if this is the right forum for this question or not.
I want a formula in cell B5 so that it firstly looks at the value in cell H1, then at the value in cell H5. It then looks at a table on a sheet called "DATA", to find the H1 value somewhere in row 1, then looks down that column until it finds the value that was in H5 on the previous sheet. When found, the value that is in column IV on the table is returned to cell B5 of the original sheet.
This needs to be repeated for cell B7 (looking up H1 and H7), then the same table on "DATA" sheet, then B9 and so on.
I can hard code the formula into each cell, B5, B7 etc.
Alternatively if possible I might be able to run a macro that would update each day when I ran it. The only thing that would change each day is the value in cell H1.
H5, H7 etc, and the table on the "DATA sheet always remain the same.
Can anyone please assist, and if this is not the right forum, could you please advise where I should post this.
cheers
Koala
I am not sure if this is the right forum for this question or not.
I want a formula in cell B5 so that it firstly looks at the value in cell H1, then at the value in cell H5. It then looks at a table on a sheet called "DATA", to find the H1 value somewhere in row 1, then looks down that column until it finds the value that was in H5 on the previous sheet. When found, the value that is in column IV on the table is returned to cell B5 of the original sheet.
This needs to be repeated for cell B7 (looking up H1 and H7), then the same table on "DATA" sheet, then B9 and so on.
I can hard code the formula into each cell, B5, B7 etc.
Alternatively if possible I might be able to run a macro that would update each day when I ran it. The only thing that would change each day is the value in cell H1.
H5, H7 etc, and the table on the "DATA sheet always remain the same.
Can anyone please assist, and if this is not the right forum, could you please advise where I should post this.
cheers
Koala