StaffsLebowski
New Member
- Joined
- Nov 18, 2009
- Messages
- 22
Can anybody help with what seems like a simple problem?
I have two columns:
1 - Course Title (Has a combo box that references the range shown below)
2 - Course Reference
When a User selects a value from the Course Title combo box, the Course Reference (using the VLookup shown below) is automatically populated.
=IF(ISBLANK(C2),"",IF(LEN(VLOOKUP(C2,CourseList!$A$1:$B$65535,2,FALSE))>0,VLOOKUP(C2,CourseList!$A$1:$B$65535,2,FALSE),""))
What I'm trying to achieve, is to have two combo boxes. This will allow a User to select either a Course Title or a Course Refence and automatically populate the other field. This seemed quite strange forward at first but I keep getting a circular reference problem that I don't know how to get round.
Any solutions greatly appreciated.
Many thanks,
Staffs Lebowski
COURSE RANGE
----------------------------
CourseTitle: CourseRef:
----------------------------
MyCourse01 1
MyCourse02 2
MyCourse03 3
I have two columns:
1 - Course Title (Has a combo box that references the range shown below)
2 - Course Reference
When a User selects a value from the Course Title combo box, the Course Reference (using the VLookup shown below) is automatically populated.
=IF(ISBLANK(C2),"",IF(LEN(VLOOKUP(C2,CourseList!$A$1:$B$65535,2,FALSE))>0,VLOOKUP(C2,CourseList!$A$1:$B$65535,2,FALSE),""))
What I'm trying to achieve, is to have two combo boxes. This will allow a User to select either a Course Title or a Course Refence and automatically populate the other field. This seemed quite strange forward at first but I keep getting a circular reference problem that I don't know how to get round.
Any solutions greatly appreciated.
Many thanks,
Staffs Lebowski
COURSE RANGE
----------------------------
CourseTitle: CourseRef:
----------------------------
MyCourse01 1
MyCourse02 2
MyCourse03 3