| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
more if statements and vlookups
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)))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 VLookups | Excel Worksheet Functions | |||
| IF STATEMENTS COMBINED WITH VLOOKUPS | Excel Worksheet Functions | |||
| Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
| VLOOKUPS | Excel Discussion (Misc queries) | |||
| Pivot tables, IF statements, vlookups? | Excel Worksheet Functions | |||
Threaded Mode
