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
Bookmarks