Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 01-08-2014, 03:06 PM
SteveWcg SteveWcg is offline IF statement, AND & Vlookup on 3 condition that's not in numeric Windows 7 64bit IF statement, AND & Vlookup on 3 condition that's not in numeric Office 2013
Novice
 
Join Date: Jun 2013
Location: Sydney Australia
Posts: 22
SteveWcg is on a distinguished road
Default

Quote:
Originally Posted by JulieB View Post
Hi Pecoflyer,

It doesn't works for my work with the formula given.
You need to go google Product() as an array vs Range as it confuses the buggery out of me every time I try to use it.

To make it work on the work spreadsheet you need to set the array, can't remember how, or use the vlookup trick of concatenating the key in the target sheet.
There's a way to do a backwards vlookup but forgotten how.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statement, AND & Vlookup on 3 condition that's not in numeric Macro - replace with condition ubns Word VBA 1 05-02-2012 12:52 AM
IF statement, AND & Vlookup on 3 condition that's not in numeric check with condition karti Word 2 03-15-2011 06:06 AM
IF statement, AND & Vlookup on 3 condition that's not in numeric Formula in a Cell with condition? Learner7 Excel 1 07-19-2010 10:10 AM
IF statement, AND & Vlookup on 3 condition that's not in numeric Vlookup and If statement problem bunnygum Excel 1 03-24-2009 05:10 AM
Retrict Method Condition markp Outlook 0 12-22-2005 05:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft