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.
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.