3 Vlookups from 2 Values

[ceytl]

Hello All,

Sheet 1: I need cell E6 to return the correct amount based on two values

1^st value is A6 the Model#
2^nd value is C12 the Qty.

If C12 is below 5 then the result is 0

If C12 = 6-7, then I need a lookup on Sheet 2 that searches Sheet 1’s A6 Model#, on Sheet 2: Column A list Model#’s, range from A4:A55

I need it to return value from Column B range from B4:B55

If C12 = 8-9, then I need a lookup on Sheet 2 that searches Sheet 1’s A6 Model#, on Sheet 2: Column A list Model#’s, range from A4:A55

I need it to return value from Column C range from C4:C55

If C12 = >10, then I need a lookup on Sheet 2 that searches Sheet 1’s A6 Model#, on Sheet 2: Column A list Model#’s, range from A4:A55

I need it to return value from Column D range from D4:D55

Thanks for your help!
<style> <!-- /* Font Definitions */ @font-face {font-family:"ＭＳ 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-formatther; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:"ＭＳ 明朝"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:128; mso-generic-font-family:roman; mso-font-formatther; mso-font-pitch:fixed; mso-font-signature:1 134676480 16 0 131072 0;} @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-family:Cambria; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"ＭＳ 明朝"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @Page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} --> </style>

 

[AlanY]

try

=IF(C12<=5,0,VLOOKUP(A6,Sheet2!A4:$D$55,IF(C12<=7,2,IF(C12<=9,3,4)),0))