Results 1 to 10 of 10

Generate a form IF another cell has a specific value but otherwise use vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Newton Abbot, England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Generate a form IF another cell has a specific value but otherwise use vlookup

    I have posted before but i am trying to hit my problem from a different angle , heres what i am trying to do...

    I enter data into a cell (Say A1) from a data validation list which includes the "Specific value"
    the next cell (B1) uses VLOOKUP for its corresponding data
    (C1) also does this but returns a different column

    If the value in A1 is specific value (eg "*" ) from the list I would like a manual input of the values for B1 and C1

    This whole process occurs around 280 times on the sheet .

    I am green onthe use of VBA but recgonise it probably uses Range and ActiveCell

    Can someone PLEASE help
    Last edited by Wobbles; 09-20-2011 at 02:47 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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