vlookup and combo box

[Tom57]

<TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=440 border=0 x:str><COLGROUP><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl22 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 330pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 65.25pt; BACKGROUND-COLOR: transparent" width=440 colSpan=7 height=87 rowSpan=5>Hi There,
<TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=440 border=0 x:str><COLGROUP><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 330pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 65.25pt; BACKGROUND-COLOR: transparent" width=440 colSpan=7 height=87 rowSpan=5>when the user selects any Product Type from the drop down (Except the Grand Total); I want to use vlookup and pull the data from table1. But when the user selects Grand Total from the drop down, I want the data to be pulled from Table2. Is there a way i can attached a sample file in this forum?.
thanks.
</TD></TR><TR style="HEIGHT: 12.75pt" height=17></TR><TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19></TR><TR style="HEIGHT: 12.75pt" height=17></TR><TR style="HEIGHT: 12.75pt" height=17></TR></TBODY></TABLE>
</TD></TR><TR style="HEIGHT: 12.75pt" height=17></TR><TR style="HEIGHT: 14.25pt; mso-height-source: userset" height=19></TR><TR style="HEIGHT: 12.75pt" height=17></TR><TR style="HEIGHT: 12.75pt" height=17></TR></TBODY></TABLE>

 

[Peter_SSs]

Is there a way i can attached a sample file in this forum?.

Welcome to the MrExcel board!

You cannot attach a file, but you can post small screen shots with Excel jeanie