+ Reply to Thread
Results 1 to 4 of 4

vlookup needed - or And if formula

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    4

    vlookup needed - or And if formula

    Red Shoes Market
    Green Tie Shop
    Blue Shoes Market
    Green Dress Market
    Blue Tie shop


    The table above is my core data - what I am trying to do is provide a lookup that will do the the following:

    eg new data is : Blue Shoes ...............

    I need formula that will look for Blue in Column A:A then (And?) look for Shoes in Column B:B and return "Market".

    Any help most appreciated.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    See attached ...
    Attached Files Attached Files
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-16-2007
    Posts
    4
    Carim - you are a life saver - many many thanks

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad it fixed your problem ...

    Thanks a lot for the feedback

+ 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