Forumla help

[lindley]

Hi,
I am not even sure the type of formula that I need but I need to be able to copy something from one column into another column based on the value of a column...

This probably makes no sense so I will explain with a picture..
Column A Column B Column C
100 Address1
200 Address2
300 Address3
100
300
200
300
200
100
100


So I want to know how to match the address in column C with the value in column A....
Everyone that has 100 in Column A needs to have Address1 in Column C, Everyone that has 200 in Column A, needs to have Address2 in Column C.

Please help

 

[Artik]

=CHOOSE(A1/100,"Address1","Address2","Address3")

Artik

 

[lindley]

Hi Artik,
Thanks for your help. This works great, but my data is actually much more complicated. I have about 20,000 different addresses and about 15,000 different numbers in the first column that i need to match up. Do you have any advice? I think it is a vlookup formula.

Thanks!!

 

[bschwartz]

Maybe something like this?

Excel 2010
	A	B	C	D	E
1	Value	Address		VLOOKUP Table
2	100	Address 1		100	Address 1
3	200	Address 2		200	Address 2
4	300	Address 3		300	Address 3
5	100	Address 1
6	300	Address 3
7	200	Address 2
8	300	Address 3
9	200	Address 2
10	100	Address 1
11	100	Address 1
Addresses

Cell Formulas
Range	Formula
B2	=VLOOKUP(A2,$D$2:$E$4,2,0)

 

[Artik]

Or formula in B2

=IFERROR(VLOOKUP(A2,$D$2:$E$4,2,0),"LACK!")

Artik