vlookup command to highlight cell in table

Hi There..

Im new here.. My name is Malcolm..
Im doing a v lookup document which is a small table which has names and numbers. The numbers are blood levels taking through out the day. Its an assignment.

I have a vlookup and match formula working
=VLOOKUP(B12,A1:I7,MATCH(B13,A1:I1,0),FALSE).
What i would like is to highlight the cell in the table to which the vlookup just displayed its value.

So if i enter "joe" and time period = Midday, the result would be 4.20. So I want the cell that has joes value at midday highlighted.

Can you point me in the right direction. Its excel 2007/2010.

Thanks in advance

Hi Fotis1991,

Thanks for your help.
Im not sure if i understand your answer. But i have attached my file incase i explained it wrong.

If you drop down the name and the time it gives a decimal number.
I want to highlight the value in its original location in the table.
The file should help in case i explain badly.

Great Thanks

Its not even part of the assignment but i wanted to get it done..I always try to expand on the assignments i get. Its a great way to learn..

its a strange method of learning that our teacher uses. We have no experience in excel but we have this statistics assesment, that uses vlookups, and combined formulas. We can talk to our friends and look up the internet to find the answers. At the end we have to write a document explaining how we done everything. Its a good way to learn instead of listening at 9pm in a class.


Thanks again.. Now i will get back to the real questions he asked us.

Hi Fotis
I wonder if you would check a difference in my figures. I am doing a similar question to the dropdown box which displays the blood levels.
This time i choose Joe and get his average using =AVERAGE(VLOOKUP(F13,A2:I7,{2,3,4,5,6,7,8,9},0)) F13 is The username field as before. a2:i17 is the range of numbers etc. It gave me an average of 4.80
What i noticed is the result on screen is different than a basic =AVERAGE(B6:$I$6) formula. But when i click Fx and looked at the argument the answer in the dialog box was the same as =AVERAGE(B6:$I$6) which is 5.09. Why is this.

Thanks

"Ctrl+Shift+Enter v. just enter"

Thats all i had to do protonLeah.
its the little things in programming that catches us out.Apart from zero experience in this type of excel. But the Internet is a great toolbox.

Thanks.