Pete,

Many thanks for the reply, this is very close, but something is broken.

C3 = "FUJITSU AUSTRALIA LTD"
C4 = "NSW"
Your formula is in D4 and = "Di Data - NSW" - Which is wrong! But every
other possible configuration for C3 works perfectly, it does not make any
sense, but then I am still trying to get to grips with you formula.

C11 - C14
Di Data - NSW
Di Data - VIC, SA, WA
Fujitsu Aust (North)
Fujitsu Aust (South)

D11 - D14
DIMENSION DATA AUSTRALIA PTY LTD
DIMENSION DATA AUSTRALIA PTY LTD
FUJITSU AUSTRALIA
FUJITSU AUSTRALIA

E11 - E14
DIMENSION DATA
DIMENSION DATA
FUJITSU AUSTRALIA LIMITED
FUJITSU AUSTRALIA LIMITED

F13 - F14
FUJITSU AUSTRALIA LTD
FUJITSU AUSTRALIA LTD

G11 - G14 - blank

H11 - H14
NSW
VIC, SA, WA
QLD, NSW, NT, ACT
VIC, WA, SA, TAS



--
Trefor


"Pete_UK" wrote:

I forgot to say that I've assumed that you have data to row 100 -
change all instances of 100 if you have more rows.

Hope this helps.

Pete

On Jul 7, 12:04 pm, Pete_UK wrote:
You can use COUNTIF to see if there is more than one match between C3
and the data in columns D E F or G, so you could try something like
this:

=IF(COUNTIF(D11:G100,C3)=0,"Not
present",IF(COUNTIF(D11:G100,C3)1,INDEX(C11:C100, MATCH(C4,H11:H100,0)),INDÂ*EX(C11:C100,IF(ISNA(MAT CH(C3,D11:D100,0)),IF(ISNA(MATCH(C3,E11:E100,0)),I F(Â*ISNA(MATCH(C3,F11:F100,0)),MATCH(C3,G11:G100,0 ),MATCH(C3,F11:F100,0)),MATCHÂ*(C3,E11:E100,0)),MA TCH(C3,D11:D100,0)))))

All one formula - be wary of spurious line breaks in the newsgroups.

Hope this helps.

Pete

On Jul 7, 11:16 am, Trefor wrote:



Sorry I meant to add that I only need to get the C4 match if there is more
than one match for C3. So if the C3 match is unique that is good enough..

Any help at all would really be appreciated.

--
Trefor

"Trefor" wrote:
There is to be a lot of discussion on multiple column lookups but they are
exact matches and I just can't wrap my head around this one.

I have 2 text values in C3 and C4.

C3 needs to exactly match a value from column D, E, F or G. (column headings
at row 10, so data from 11 down).

C4 must be found within a list of CSVs in each cell in column H. (column
headings at row 10, so data from 11 down).

I then need the value under the heading in Column C that matches the same row.

--
Trefor- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -