+ Reply to Thread
Results 1 to 3 of 3

Match, IF , Vlookup

Hybrid View

  1. 05-09-2010, 11:05 PM #1
    Shermaine2010
    Shermaine2010 is offline
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Match, IF , Vlookup

    I need help.. Please see the attached sheet.

    What formula should put the show 130 show as Guava.

    Thanks in advance.

    Shermaine.
    Attached Files Attached Files
    Last edited by Shermaine2010; 05-10-2010 at 02:38 AM.
    Reply With QuoteRegister To Reply
  2. 05-09-2010, 11:56 PM #2
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Need help :Match, IF , Vlookup problem

    Hi Shermaine2010

    Maybe

    =IF(E13="","", IF(ISNUMBER(MATCH(E13,B4:B7,0)),VLOOKUP(E13,$B$4:$C$35,2,0),VLOOKUP(E13,$E$4:$F$35,2,0)))
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
  3. 05-10-2010, 02:24 AM #3
    Shermaine2010
    Shermaine2010 is offline
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Re: Match, IF , Vlookup

    hi Pike,

    Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1