IH8PunkRok Posted April 6, 2011 Report Share Posted April 6, 2011 (edited) so here is the deal. i have a code in the first column and a full addy in the next column which spans 3 rows per code like so GO.....Comp. Name .......Street addy .......city, State, zip, (hopefully that formatted correctly) i can use a VLOOKUP function to find the comp name using the code that is easy. my issue is getting the street addy. im not sure how i can define which row to take information from. any help? Edited April 6, 2011 by IH8PunkRok Quote -Matt2005 Dodge Magnum RTJVC KD-AVX1 2 PPI S580.2 Obsidian Audio ST1 Horn Tweeters PRV 8MB450s Audio Legion 3500.1D 2 RE MT 18s 360 ah LiFePO4 BatterySHCA 2/0 155.2 @ 29 hzKicker CVR 15's buildDD 3512e buildMini T-Line Build(6) 8s BuildNightshade 15s Wall BuildMagnum AB XFL 12s BuildNewest Magnum Build Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.