formula error. how do I add a new if/vlookup criteria?

[teikma]

Here's a link to some screen captures of what I have.... Imgur


This is the formula I'm using now and it works fine with no errors.....
=IF(D12=704,VLOOKUP(B12,Table1[#All],7),VLOOKUP(D12,'Pivot by Account'!$A$4:$D$10,4))



But I need to add an additional criteria.... if cell D12 is 704 and B12 on the original Table1 lookup is blank, I need look up a value in cell A12 and the output needs to be from a column in the table

=IF(D12=704,VLOOKUP(B12,Table1[#All],7),if(B12"",vlookup(a12,Table1[#All],7)),VLOOKUP(D12,'Pivot by Account'!$A$4:$D$10,4))

I am getting an error on this part ...B5""
forgive me if I didn't post my question correctly, this is my first post.

 

[oldbrewer]

=if(d12=704,if(b12="",vlookup(a12,table1[#all],7),vlookup(b12,table1[#all],7),vlookup(d12,'pivot by account'!$a$4:$d$10,4)))

 

[teikma]

thank you oldbrewer, I copy/pasted that formula and I received the following error message:
You've entered too many arguments for this function.

 

[oldbrewer]

=if(d12=704,if(b12="",vlookup(a12,table1[#all],7),vlookup(b12,table1[#all],7)),vlookup(d12,'pivot by account'!$a$4:$d$10,4))

my error - i think it needs 2 close brackets after the 7 and then one less at the end

it means if x, if y, something or something else, something different

something different comes in where if x is not true, something comes in where x and y are true and something else comes in when x is true and y is not true

 

[teikma]

yes yes yes!!!! that worked!! thank you so much!!!!