I need to create a searchable excel sheet that will allow me to find information based on zip codes. I want to type in a zip code on a "search sheet" and have only the information pop up from a data sheet with only the relating info from a particular zip code. I have attached an example of what I want to happen
See if this is ok
Marcelo Branco
Enter in B4 and drag it across and down
**Data must be sorted by the zip code
=IF($A$2="","",IF(OFFSET(data!$F1,MATCH($A$2,data!$F$2:$F$5,0),COLUMN($A1)-1)<>$A$2,"",OFFSET(data!$F1,MATCH($A$2,data!$F$2:$F$5,0),COLUMN(A1)-6)))
Last edited by AlKey; 09-27-2013 at 10:53 PM. Reason: Corrected formula
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks