+ Reply to Thread
Results 1 to 4 of 4

IF and Vlookup Formula Assistance Please!

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    Anaheim, CA
    MS-Off Ver
    MS365
    Posts
    63

    IF and Vlookup Formula Assistance Please!

    Hello!

    In my spreadsheet, i have two tabs. The first tab named "Data" - I would like to know what Vlookup formula to enter in C4 that would give me the answer "Mens Hats" which would come from my 2nd tab named Styles list tab.

    The styles list tab contains 3 columns - Store, Styles and Project. The styles column contains 5 styles.

    So in my data tab, if i enter a formula on C4 - what formula would give me the answer as "Mens Hats" as long as the store and style match from the Styles List tab

    Please help!
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,038

    Re: IF and Vlookup Formula Assistance Please!

    Here, try this:;
    Attached Files Attached Files
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    07-20-2013
    Location
    Anaheim, CA
    MS-Off Ver
    MS365
    Posts
    63

    Re: IF and Vlookup Formula Assistance Please!

    Thank you !!! it did work. But it seems if my data goes beyond 1000 rows, then the formula doesnt work or maybe is it because the { is gone if it try to update the 1000 to 3000 rows?

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,038

    Re: IF and Vlookup Formula Assistance Please!

    Yes. Change 1000 into 10000 to be sure.
    And confirm with ctrl+shift+enter (not just enter)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup/If formula assistance
    By Jess0121 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2014, 03:18 PM
  2. [SOLVED] Assistance with my VLOOKUP Formula....Please help...
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2013, 08:52 PM
  3. [SOLVED] Assistance with PTO Accrural Possible VLOOKUP Formula
    By bwelter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-10-2013, 10:00 PM
  4. vlookup formula assistance
    By jman667 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2013, 04:58 PM
  5. Replies: 2
    Last Post: 04-05-2010, 05:13 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