VLookup not working in conjunction with combobox

tmcrouse

Board Regular
Joined
Apr 10, 2012
Messages
118
I have a worksheet1 with 3 columns. First column starts on A2 cuz of the column header. Second column B2, Thirs column C2. I have an Excel form1 that I have 1 combobox in A2, textbox B2, textbox C2. I have copied the comboxbox from A2 all the way to A200 and populated the information from worksheet1. I am now trying to create my vlookup to say if you see value X in A2 then put data from worksheet1 B2 to form1 B2 and data from worksheet1 C2 to form1 C2.

Example:
A2 B2 C2
Masectomy Breast Left
Colon Lower Partial
Esphagous Upper Partial

form

A2 combobox
B2 text field populate
C2 text field populate

Formula I tried does not work:

=IF(ISNA(VLOOKUP(A2,program!A2:C200,2,0))," ",VLOOKUP(A2,program!A2:C200,2,0))
=IF(ISNA(VLOOKUP(A2,program!A2:C200,3,0))," ",VLOOKUP(A2,program!A2:C200,3,0))
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,431
Members
409,876
Latest member
Akash Yadav
Top