A simple problem but it's had me stumped.
I have a friend who has asked me for help on a problem - so here go's
He wants to take data from a large number of coloums, using the top row and logic to take the data from within the specificed coloum. Now he does not want to use code (otherwise it would be done by now!!!).
So say the data looks like this:
mike John Andrew Bob
1 5 6 7
2 8 9 10
3 11 12 13
4 14 15 16
A1 = "mike"
A2 = 3
A3 = Hlookup(B1:B4,A1,false) & whatever to locate the correct row
what he wants is in two cells, the first to specify the offset value looking down the rows, the second to define the name. So say using HLookup we find the name in the defined range for the top row, he now wants to count down the rows to locate the actual value he is after. Where I'm stuck is combing the Hlookup and the offset arguments within one cell so that if the Hlookup is finding "mike" (which is the cell value in say A1) and then counting down 3 rows (which is the cell value in A2).
I'm using Excel 2003 (which I hate - much prefer 2000!!) so any help would be appreciated - Thanks Phil