Results 1 to 9 of 9

Using the IF and VLOOKUP function togehter

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    8

    Using the IF and VLOOKUP function togehter

    My formula is in cell M3

    In cell B2 I am choosing from a list - Stage 1, Stage 2, Stage 3, Stage 4, Stage 5

    In cell K3 I am choosing from a list - Draft, In Process, Complete

    I have created a table to work off - it should be attached.

    In cell M3 I want to say that depending on what is picked in B2 to look at that table and bring back the desired result.

    How do I do this - I have looked at IF + VLOOKUP but I'm not sure it's what I want??

    Please & thank you
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  2. Need help nesting an index/match function within a Vlookup function.
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 06:16 PM
  3. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  4. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  5. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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