Auto populate a cell when 3 options are selected

**Paul** · 06-28-2011, 05:41 PM

Hi Dizzle,

Hopefully this formula will work for you:

=IF(COUNTA(A32:H32)=3,IFERROR(VLOOKUP(A32&D32&G32,ALL!D:E,2,0),"DOES NOT EXIST"),"")

In Excel 2003 or earlier you would need to change it to:

=IF(COUNTA(A32:H32)=3,IF(ISNA(VLOOKUP(A32&D32&G32,ALL!D:E,2,0)),"DOES NOT EXIST",VLOOKUP(A32&D32&G32,ALL!D:E,2,0)),"")

**dizzle** · 06-28-2011, 06:03 PM

Originally Posted by Paul

Hi Dizzle,

Hopefully this formula will work for you:

=IF(COUNTA(A32:H32)=3,IFERROR(VLOOKUP(A32&D32&G32,ALL!D:E,2,0),"DOES NOT EXIST"),"")

In Excel 2003 or earlier you would need to change it to:

=IF(COUNTA(A32:H32)=3,IF(ISNA(VLOOKUP(A32&D32&G32,ALL!D:E,2,0)),"DOES NOT EXIST",VLOOKUP(A32&D32&G32,ALL!D:E,2,0)),"")

you = amazing.

Thanks!