Excel Problem

[Rainbowhawk]

SourceIDEFinYEftPTypeSub Type 1Sub Type 2Sub Type 3%change1201411****5220153Air Purifying***7320154Air PurifyingFilters**3420152Air PurifyingFiltersHood*4520152Air PurifyingFull FaceM SeriesM-9849201411Air PurifyingEscapeHoodHood Civic2QuestionsEFinYEftPTypeSub Type 1Sub Type 2Sub Type 3Answer %Change201411**** 20152Air PurifyingFiltersHood* 201411Air PurifyingEscapeHoodHood Civic

I am trying to create a lookup on 6 criteria, I am thinking this will be an array query and may need to use VBA to deal with wildcards, can anyone help

Tim

 

[Rx_]

Can you post a small spreadsheet with example and let us know what the general objective is?

 

[Brianwarnock]

well he has not come back, but I seem to remember that you can use wildcards in Match and concatenate the criteria etc .

Brian

 

[jaismith08]

spreadsheet is my favorite..