+ Reply to Thread
Results 1 to 2 of 2

how to vlookup out the firgue under two critiria

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    Australia
    MS-Off Ver
    Microsoft Professional 2010 plus
    Posts
    55

    how to vlookup out the firgue under two critiria

    Please see below , I need to vlookup out the rate, thanks

    Name style Rate
    Daley Michael Normal 28.69
    Daley Michael TH 34.36
    Daley Michael DT 45.07
    Daley Michael Meal 13.86
    Powell Stephen Normal 28.69
    Powell Stephen TH 34.36
    Kopta Tomasz Normal 28.69
    Kopta Tomasz TH 34.36
    Kopta Tomasz DT 45.07
    Kopta Tomasz Meal 13.86
    Kopta Tomasz PH 57.95
    Fernando Arancibia Meal 13.04
    Fernando Arancibia Normal 27.83
    Fernando Arancibia TH 34.9001
    Fernando Arancibia DT 45.8814
    Fernando Arancibia PH 61.6078
    Gavin Sweet Meal 13.04
    Gavin Sweet Normal 27.83

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: how to vlookup out the firgue under two critiria

    Okay then look here http://www.contextures.com/xlfunctions02.html or look in the Excel help for vlookup. Have you tried something as of yet? You have not supply much info here.

    Maybe attach a workbook of sample data, what you have and what you expect after you have looked up those sites provided.
    HTH
    Regards, Jeff

+ 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