Nested If(AND..........9 arguments required

[Guest]

Hi all

I have a spreadshee
A B C D E F
1 Name 1 Name 2 Name 3 Concatenated Name 4 Name 5 Name
3 Bob Bob Smith Smit
4 Harry Harry Jones Jone

Ok.........in Cells A3:C3 only one entry is allowed and the same for E3:G3

Col D is the result I need

I need something like

If(and(A3>0,E3>0),A3&" "&E3...........but for the nine combinations
A
A
A
B
B
B
C
C
C

Any ideas

Thanks for readin

A

 

[Mark]

Hi

I suggest try the DGET function.
I have used it recently for this kind of thing and it works well (search
this group for instances)

From Excel help:
Extracts a single value from a column of a list or database that matches
conditions you specify.

Syntax

DGET(database,field,criteria)

Mark

Hi all,

I have a spreadsheet
A B C D

E F G

 

[Guest]

Thanks Mar

Sussed i

=G5&""&H5&""&I5&""&L5&""&M5&""&N

Shees

A