Thread: Find values in table and return correpsonding data in array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryan ryan is offline
external usenet poster
  
Posts: 46
Default Find values in table and return correpsonding data in array
I'm not sure if you can do this in an array function or if it takes programming, but I am trying to search a database for multiple entries and display corresponding data separately in a new table. For example,

1 Red
2 Blue
1 Green
3 Yellow

I would like to create a new table that pulls out the data in column 2 if column 1 equals "1", like this...

Red
Green

Does anyone know if I can do this? I've tried VLOOKUP, INDEX & MATCH, and OFFSET & MATCH. Thank you.
Reply With QuoteReply With Quote