Hello,
I'm getting a headache by the solving the following:
I have constructed a table that contains scores per person per day. In another table I would like display the scores per person on the basis of a day that can be selected. (see the attached file)
I tried VLOOKUP/HLOOKUP but all it did was giving me a headache, no results...
Maybe someone can give me a hint? Much Appreciated!
Regards,
Mike
=INDEX($C$5:$I$12,MATCH($B20,$B$5:$B$12,0),MATCH($D$18,$C$4:$I$4,0))
Copy the formula down
Regards
Hello!
Ive got similar problem, everything is described in the attached file.I dont know why, but when I copy the function you advised to the sheet above it doesnt work. Secondly, I dont know how to customize it for my document. So I would be very pleased if you could help me!
Thank you very much.
Regards
Hello D-Fransen, Welcome to the forum!
Also try,
C20, copy down.
=HLOOKUP($D$18,$C$4:$I$12,MATCH(B20,$B$4:$B$12,0),0)
Or,
=VLOOKUP(B20,$B$5:$I$12,MATCH(D$18,$B$4:$I$4,0),0)
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks