CFSbookkeeper
New Member
- Joined
- Sep 16, 2011
- Messages
- 3
I've run into a problem. In my Package Table tab, some times I will want to return 5 products, sometimes only 3 (depending on how many items make up the package). Where and how do I put in an if statement to not fill in anything if B$6 & B$7 thru V$6 & V$7 (in the Package Table) don't have values?
=HLOOKUP(B$12,'Package Table'!B$2:V$7,ROWS(C$12:C12)+<WBR>1,0)
Or maybe there is a better way to do this?
=HLOOKUP(B$12,'Package Table'!B$2:V$7,ROWS(C$12:C12)+<WBR>1,0)
Or maybe there is a better way to do this?