Excel Problem (1 Viewer)

R

Rainbowhawk

Registered User.

Local time

Today, 08:50

Joined

Oct 8, 2007

Messages

54

• Jun 30, 2014

• #1

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_

Nothing In Moderation

Local time

Today, 01:50

Joined

Oct 22, 2009

Messages

2,803

• Jun 30, 2014

• #2

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

 

Brianwarnock

Retired

Local time

Today, 08:50

Joined

Jun 2, 2003

Messages

12,701

• Jul 1, 2014

• #3

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

Brian

 

J

jaismith08

Banned

Local time

Today, 00:50

Joined

Jul 5, 2014

Messages

9

• Jul 5, 2014

• #4

spreadsheet is my favorite..