I am trying to reference another worksheet with a retail value and a
wholesale value based on a value entered on the purchase sheet (r for retail
and w for wholesale). This is what I have entered and it isn't working.

=IF(E7="R",(VLOOKUP('b14,Pet Store
Database'!$A$8:$G$75,7,FALSE)),IF(E7="W",(VLOOKUP( 'b14,Pet Store
Database'!$A$8:$D$75,4,FALSE))))