How to use Lookup / Index to fetch data by matching two cells

[jilaba]

Column A & B have Data. When I put a entry in D cell, it should be matched with A cell & return corresponding B cell value in Cell E. I used lookup, which is working in small data, but in case of large data, it is not working.

Please help/

[Fluff13]

How about
=INDEX($B$2:$B$20,MATCH(D2,$A$2:$A$20,0))

[jilaba]

How about
=INDEX($B$2:$B$20,MATCH(D2,$A$2:$A$20,0))

Thanks a lot, it solved.

[Fluff13]

You're welcome & thanks for the feedback

[tim201110]

=lookup(d2,$a$2:$b$1350)