I am trying to build a function that will look for 3 separate values in the same row, and if they all match, display a different column in that matching row.

I have been trying to use Nested VLOOKUP commands but am not able to get it working.

Below is an example of the data I am trying to use. (There are 4 Columns)

Alltel Alltel 0 10,906
Alltel AT&T 0 1,270,022
Alltel CBW 0 2,270
Alltel Cricket 0 143,810
Alltel Sprint 0 678,433
Alltel T-Mobile 0 547,134
Alltel Alltel 1 20,640
Alltel AT&T 1 791,268
Alltel CBW 1 1,399
Alltel Cricket 1 113,386
Alltel Sprint 1 436,989
Alltel T-Mobile 1 375,586
Alltel Verizon 1 914,387

As an example, I would like to be able to have a function like this..

If Column A=Alltel and Column B=AT&T and Column C=1 then display Column D

Any help is greatly appreciated