+ Reply to Thread
Results 1 to 2 of 2

big trouble with combobox/vlookup

  1. #1
    soulfear
    Guest

    big trouble with combobox/vlookup


    hi there, im setting up a form and this is what i got so far,

    sheet1(data) with a table from A2:K106, sheet2(form) has a scanned pic
    and some formatted cells where i want my vlookups to work in, the
    first 2 are formatted 5 columns by 2 rows (C7:G8,C11:G12) and the other
    6 cells are 1 column by 2 rows (I7:8,I11:12,I15:16,K7:8,K11:12,K15:16).

    iv used form comboboxes, control toolbox and data valadation but
    nothing seems to work with the vlookups this is what iv been using

    =VLOOKUP(B3,CommonName,3,FALSE)

    B3 was the cell i linked the form combobox to, and thats about it i
    think all the rest was trial and error, lots of error haha help!


    --
    soulfear

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486
    when you say the cells are formatted, how do you mean?

+ 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