Thread: Extracting data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Whit Whit is offline
external usenet poster
 
Posts: 13
Default Extracting data

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)