big trouble with combobox/vlookup

S

soulfear

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 pi
and some formatted cells where i want my vlookups to work in, th
first 2 are formatted 5 columns by 2 rows (C7:G8,C11:G12) and the othe
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 bu
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
think all the rest was trial and error, lots of error haha help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: vlookup from multiple sheets and spreadhseets 1
Trouble with ActiveX Control - Combo Box 4
Change data with a macro 8
Macro to change information 0
If statement with Vlookup - including ISNA function to compare two columns from different worksheets 4
IF and VLOOKUP Functions 1
Input boxes 5
Macro to shift to next row 2

Top