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!

when you say the cells are formatted, how do you mean?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=540880