HELP PLEASE - How do I get a column to read 3 VLOOKUPs

[MYeag]

I have customer templates that uses information from VLOOKUPs on other worksheets in the same workbook. On the customer template, I have a column that has a price effective date. I am trying to get this column to look in 3 places based on what each cell has and am not sure how to do it.

Currently I have the price effective date on the customer template looking at 2 columns - here is the formula I currently have: =VLOOKUP(P51,'Master Price Sheet'!$C$1:$Q$20967,8+(VLOOKUP(P51,'Master Price Sheet'!$C$1:$Q$20967,8,0)=0),0)

This is what I need it do - I sent you a screen shot of my 3 columns with 2 samples of how it looks.
The Effect Date (column 10)is the date currently in the system.

The New Effect Date (column 9)is the price increase date =VLOOKUP(G:G,'Product List - % Increase'!$D$35:$F$1099,3,FALSE)

The Price Protection Date (column 8)is the effective date configured based on the # of days we have given each customer with a price protection =VLOOKUP(B:B,'Price Protection'!$A$2:$Q$277,17,FALSE)

I need the formula to say - if the new effective date is 1/01/1900 (0) use the effect date. If the new effective date is greater than 1/1/1900 (0) use the price protection date.

<TABLE style="WIDTH: 244pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=326><COLGROUP><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4498" width=123><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 92pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79 height=17 width=123>Price Protection</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 96pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl79 width=128>New Effective Date</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl80 width=75>Effect Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl81 height=17>8/1/2011</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl81>7/1/2011</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 align=right>2/15/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl81 height=17>8/1/2011</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl81>1/0/1900</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl78 align=right>2/15/2011</TD></TR></TBODY></TABLE>

 

[MYeag]

I have figured it out. Please disregard. Thanks for all who viewed