Referencing Cells Using If Functions

[Guest]

Example:

I have 2 adjacent columns of cells (A&B), each with thousands of different
values in them. I have a known value (C1) which also exists in one of the
cells of the range of values in (B). If, hypothetically, this value in C1
exists in B2304 I want a formula to give me the value in A2304.

In other words, D1 = Ax if Bx equals C1

Can someone please help me with this? ([email protected])

 

[Guest]

Try this:

=INDEX(A1:A10000,MATCH(C1,B1:B10000,0))