Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 01-09-2014, 10:36 PM
macropod's Avatar
macropod macropod is offline IF statement, AND & Vlookup on 3 condition that's not in numeric Windows 7 32bit IF statement, AND & Vlookup on 3 condition that's not in numeric Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by SteveWcg View Post
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.
If you study the solution posted by Pecoflyer, you'll see there is no use of PRODUCT(), or array formulae, or VLOOKUP(), because none of them is necessary.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



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 10:42 AM.


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