I have database that need to quickly extract certain cells based upon an
alpha key, 5 letters. The data I need to access are in columns b-l I can't
remember how to do this. Here's the formula I am using, as an array.

=if(a2=g2:g25614, b2:l25614)

Wonder if you meant to do something like this
In say, N2: =INDEX(B$2:B$5614,MATCH($A2,$G$2:$G$25614,0))
Copy across to X2, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Whit" wrote:
I have database that need to quickly extract certain cells based upon an
alpha key, 5 letters. The data I need to access are in columns b-l I can't
remember how to do this. Here's the formula I am using, as an array.

=if(a2=g2:g25614, b2:l25614)