Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2017, 08:44 AM
josepfh josepfh is offline Vlookup Not working Properly Windows 7 64bit Vlookup Not working Properly Office 2007
Novice
Vlookup Not working Properly
 
Join Date: Apr 2017
Posts: 1
josepfh is on a distinguished road
Unhappy Vlookup Not working Properly

Hello everyone,

I am trying to get values as per their property (see image).

As you can see, there is 65 written in column D with property Excellent next to it, then on next cell I have put a formula that should search from table (on right side) and show Demand type (20, 30, 40...), in this case 20 because 65 with excellent property lies under 20 demand. Similarly, if the number comes under Very Good column then it should show respective Demand number.



I have tried searching over the internet but nothing is working. I know my formula is wrong. I wonder if you experts can help me up?

Moreover, please also tell how to put range of specific numbers in one cell, for example, 01-65, 66-75 and so.

P.S. I am not excel expert.

Many thanks for your support.

Reply With Quote
  #2  
Old 04-19-2017, 11:04 AM
NBVC's Avatar
NBVC NBVC is offline Vlookup Not working Properly Windows 7 64bit Vlookup Not working Properly Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Assuming you are looking for first match that is >= search value, try, in F1:

=INDEX($J$2:$J$6,MATCH(TRUE,INDEX(INDEX($J$2:$P$6, 0,MATCH(E1,$J$1:$P$1,0))>=D1,0),0))

copied down
Reply With Quote
Reply

Tags
vlookup

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
It seems as if wdFindStop isn't working properly tfurnivall Word VBA 3 05-06-2016 09:58 AM
VLOOKUP not working properly with data digiting, only copy&paste Mike84bs Excel 3 05-06-2015 10:01 AM
Vlookup Not working Properly Indentation Not Working Properly LaC0saNostra Word 2 02-01-2015 11:35 AM
Vlookup Not working Properly Freeze Pane isn't working properly ep2002 Excel 1 07-27-2014 06:53 PM
Vlookup Not working Properly [Publisher] Fonts not working properly pajkul Publisher 1 01-23-2011 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:16 AM.


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