I'm using Excel Visual Basis 6.3 and am NOT a programmer. What I have is a 2 worksheet file (I can put it on one if it works better). One sheet contains exported information from a database and contains 6 different columns. In each cell of the second worksheet I need to do the following:
In English: Search on this worksheet "Fares 2005" in this named range "FullFare" and if a record contains "East Division" in column G, and "1" in column c, and "521" in column A, return the number in D3
Vlookup may not be the way to go but I'm not sure how to do it in VB. I need to know the best way to do it in Excel and if is a Vlookup table how do I match 3 columns to return exactly what I'm looking for. If not what other way can I get the return I am looking for.
In English: Search on this worksheet "Fares 2005" in this named range "FullFare" and if a record contains "East Division" in column G, and "1" in column c, and "521" in column A, return the number in D3
Vlookup may not be the way to go but I'm not sure how to do it in VB. I need to know the best way to do it in Excel and if is a Vlookup table how do I match 3 columns to return exactly what I'm looking for. If not what other way can I get the return I am looking for.