+ Reply to Thread
Results 1 to 9 of 9

vlookup command to highlight cell in table

  1. #1
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    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

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: vlookup command to highlight cell in table

    Hi Malcolm and welcome to the forum.

    You can do it, using Conditional Formatting.

    Let's say that Joe name, is in A1 & Midday, is in C1.

    Then in the cell that you want to highlight, >>Format>>Conditional Formatting>>Formula is>>=AND(A1="joe",C1="Midday")>>choose color>>OK.

    Hope to helps you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: vlookup command to highlight cell in table

    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.
    Attached Files Attached Files

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: vlookup command to highlight cell in table

    Hi again.

    Always, i say, that best way to describe your problem, is to uplad, a sample workbook.

    So try this.=and($a2=$b$12;b$1=$b$13)

    I think, this is it.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: vlookup command to highlight cell in table

    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..

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: vlookup command to highlight cell in table

    Excel, is my hobby. I like to learn it day by day...

    Glad to helped you.

    Thanks for the reb*

  7. #7
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: vlookup command to highlight cell in table

    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.

  8. #8
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: vlookup command to highlight cell in table

    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

  9. #9
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,370

    Re: vlookup command to highlight cell in table

    Note that your formula is returning the value in column B alone for each name. Note that you have an array of column numbers in the formula:
    Confirm the formula with Ctrl+Shift+Enter v. just enter
    Ben Van Johnson

  10. #10
    Registered User
    Join Date
    03-03-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: vlookup command to highlight cell in table

    "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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1