barim
06-12-2017, 09:42 AM
I am trying to pull value something similar to tax tables. If Value1 (2003) is greater 2001 and less than 3000 and the code is let’s say AB, pull the value from AB column. Same thing is with Value2.
Value1 and Value2 have to satisfy criteria before value of the code can be pulled over to cell M2.
For code AC, 3050 is between 3001 and 4000 and 550 is between 501 and 600 and it is pulling value of 90 into cell M3
Attached is sample workbook.
Thank you in advance.
Value1 and Value2 have to satisfy criteria before value of the code can be pulled over to cell M2.
For code AC, 3050 is between 3001 and 4000 and 550 is between 501 and 600 and it is pulling value of 90 into cell M3
Attached is sample workbook.
Thank you in advance.