vlookup + combo boxes, referencing... plz help :'(

[kieranbeunco]

Hey everyone, I'm kinda in a pickle here. I'm pretty sure I know wha
I'm doing, but it doesn't seem to be working. Here's how my spreadshee
is set out:

All rows=height of 20
All columns=width of 3

Combo box 1 is in cell C11, range: J1:J5, Cell link=E1, Lines=5
Combo box 2 is in cell C22, range: J1:J5, Cell link=E2, Lines=5
Combo box 3 is in cell C33, range: J1:J5, Cell link=E3, Lines=5
Combo box 4 is in cell C44, range: J1:J5, Cell link=E4, Lines=5
Combo box 5 is in cell C55, range: J1:J5, Cell link=E5, Lines=5

So, for example:

- If "A1" is selected from "Combo box 1", E1 should equal "1".
- If "A2" is selected from "Combo box 1", E1 should equal "2".
- If "A3" is selected from "Combo box 1", E1 should equal "3".
- If "A4" is selected from "Combo box 1", E1 should equal "4".
- If "A5" is selected from "Combo box 1", E1 should equal "5".

And:

- If "A1" is selected from "Combo box 2", E2 should equal "1".
- If "A2" is selected from "Combo box 2", E2 should equal "2".
- If "A3" is selected from "Combo box 2", E2 should equal "3".
- If "A4" is selected from "Combo box 2", E2 should equal "4".
- If "A5" is selected from "Combo box 2", E2 should equal "5".

And:

- If "A1" is selected from "Combo box 3", E3 should equal "1".
- If "A2" is selected from "Combo box 3", E3 should equal "2".
- If "A3" is selected from "Combo box 3", E3 should equal "3".
- If "A4" is selected from "Combo box 3", E3 should equal "4".
- If "A5" is selected from "Combo box 3", E3 should equal "5".

And:

- If "A1" is selected from "Combo box 4", E4 should equal "1".
- If "A2" is selected from "Combo box 4", E4 should equal "2".
- If "A3" is selected from "Combo box 4", E4 should equal "3".
- If "A4" is selected from "Combo box 4", E4 should equal "4".
- If "A5" is selected from "Combo box 4", E4 should equal "5".

And:

- If "A1" is selected from "Combo box 5", E5 should equal "1".
- If "A2" is selected from "Combo box 5", E5 should equal "2".
- If "A3" is selected from "Combo box 5", E5 should equal "3".
- If "A4" is selected from "Combo box 5", E5 should equal "4".
- If "A5" is selected from "Combo box 5", E5 should equal "5".

ALSO

Cell G1=1, cell H1=A1
Cell G2=2, cell H2=A2
Cell G3=3, cell H3=A3
Cell G4=4, cell H4=A4
Cell G5=5, cell H5=A5

Cells H1 to G5 have been given a name, "choose".

J1="A1"
J2="A2"
J3="A3"
J4="A4"
J5="A5"

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sorry if this sounds like a load of crap, but I'm desperate, and no
very good at explaining :$

Anyway, that's all the main data, but what I want to do, is, in cel
A1, I want to put a formula in, so that if any of the combo boxe
produce "1" in their corresponding cell, cell A1 would equal the sam
value.

So for example:

If you selcect "A1" in "Combo Box 1", the corresponding cell, which i
E1, would produce "1", and cell A1 would produce the same value as E1
But if you select "A1" in "Combo box 1", a value of "0" would b
returned in cell A1.

I would like this to work for all the combo boxes. I'd imagine thi
would be almost impossible to work out, and IF possible, very long
lol.

I've attatched the Excel document to this post. If it doesn't work
then download it from my web-site. It's available for anyone t
download, but PLEASE, can someone help me with this problem!!!

http://www.angelfire.com/film/am5kat3/kieranbeunco.xml

Thanks a real lot, greatly appreciated!! Kieranbeunco :

Attachment filename: kieranbeunco.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47532

 

[Debra Dalgleish]

In cell A1, enter the following formula:

=IF(E1=G1,E1,0)

and copy down to cell A5