Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vba 97 excel lookup formula
i have this code =IF(D23="","",VLOOKUP(D23,$AA$1:$AC$3500,IF($H$18= "Woodlawn Inc",3,1),FALSE)) which will lookup the prices, if woodlawn's name is in H18 it will draw prices from a different list. i would like it to also include the "IF" for the name "spencer" as well, but when i try to extend the formula it tells me i have too many arguments. what does the formula have to look like in order to make this work. thanks -- chief ------------------------------------------------------------------------ chief's Profile: http://www.excelforum.com/member.php...fo&userid=7773 View this thread: http://www.excelforum.com/showthread...hreadid=374149 |
#2
|
|||
|
|||
Have you tried using the AND formula instead of IF? Maybe that will allow more info. -- jenbrunson ------------------------------------------------------------------------ jenbrunson's Profile: http://www.excelforum.com/member.php...o&userid=23777 View this thread: http://www.excelforum.com/showthread...hreadid=374149 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
copying LOOKUP formula | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions |