try this idea instead.
=vlookup(b14,yourlookuprng,if(e7="r",7,4),false)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AmyLRuck" wrote in message
...
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))))