vlookup with two tables

I am trying to write a formula that basically says that if cell E2 = "single" then do a VLOOKUP for E1 on table array B2:C9 with column index of 1 and exact match and if cell E2 does not equal "single" then do a VLOOKUP for E1 on table array B12:C19 with column index of 1 and exact match.

Is this possible? I've been playing around for a while and can't seem to figure it out.

Thanks!

welcome to the forum, klp. question
why do you range up 2 columns (B:C) when you only want a column index of 1?

if E1 is the lookup_value, a column index of 1 means it looks for E1 in B2:B9 & return the results in B2:B9. and of course, that's E1. so you don't even need a VLOOKUP. a VLOOKUP makes more sense if you want to return a column index of 2. so it looks for E1 in B2:B9 & returns the result of the row in Column C where E1 is found

so without understanding the whole picture, i'll just give you what you ask for:
=VLOOKUP(E1,IF(E2="Single",$B$2:$C$9,$B$12:$C$19),1,0)

a sample excel file depicting your results is always more than welcome.

ok, then you shouldn't be using exact match. you can omit the 0, put TRUE or 1.
=VLOOKUP(B11,IF(E2="Single",D7:D14,D17:D24),1)

this works too:
=LOOKUP(B11,IF(E2="Single",D7:D14,D17:D24))

just to help you in future postings, add the info in post #3 in the file where you mentioned about the desired results:

For example, if E2= "singe" and E1=10,000, I would like to get $2200. However, if E2 does not equal "single", I would like to get $8300.

your file is a great eg, with all the highlighting for us to focus on

isn't that bracket supposed to be percentage of with respect to Federal Tax Brackets? we'll i'm half around the globe so don't seem to understand it.
10%
15%
25%
28%
33%
35%
39.60%