Extracting data

  • Thread starter Thread starter Whit
  • Start date Start date
W

Whit

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
 
Back
Top