Vlookup / Match max min number on different worksheet

Posted by Dan on Stack Overflow See other posts from Stack Overflow or by Dan
Published on 2012-12-05T16:52:09Z Indexed on 2012/12/05 17:03 UTC
Read the original article Hit count: 238

Filed under:

excel

|

match

|

vlookup

I have 2 worksheets, one with company data and the other with a min max and answer column.

What i need to do is find out if value in column D in the company data is between the min/max in worksheet 2 output answer in worksheet 2.

Please can someone help. This is clearly a vlookup question but i haven't got a clue how to do the min/max.

Any help will be greatly appreciated.

worksheet 1

NAME                    TYPE    NUMBEROFEMPLOYEES   Output
Wetland Plants Ltd      Client  4   
Capital Management LLP  Clients 3   
College ltd             Clients 156

Worksheet 2

max         min     output
100000000   60000   big
59999       15000   medium
14999       0       small

Cheers guys

© Stack Overflow or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about match

JS/Jquery, Match not finding the PNG = match('/gif|jpg|jpeg|png/')

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following code which I use to match fancybox possible elements: $('a.grouped_elements').each(function(){ var elem = $(this); // Convert everything to lower case to match smart if(elem.attr('href').toLowerCase().match('/gif|jpg|jpeg|png/') != null) { elem.fancybox(); … >>> More
Cisco SR520w FE - WAN Port Stops Working

as seen on Server Fault - Search for 'Server Fault'
I have setup a Cisco SR520W and everything appears to be working. After about 1-2 days, it looks like the WAN port stops forwarding traffic to the Internet gateway IP of the device. If I unplug and then plug in the network cable connecting the WAN port of the SR520W to my Comcast Cable Modem, traffic… >>> More
preg_match to match an optional string, but not match all of the string

as seen on Stack Overflow - Search for 'Stack Overflow'
Take for example the following regex match. preg_match('!^publisher/([A-Za-z0-9\-\_]+)/([0-9]+)/([0-9]{4})-(january|february|march|april|may|june|july|august|september|october|november|december):([0-9]{1,2})-([0-9]{1,2})/([A-Za-z0-9\-\_]+)/([0-9]+)(/page-[0-9]+)?$!', 'publisher/news/1/2010-march:03-23/test_title/1/page-1'… >>> More
Google Contacts Error: If-Match or If-None-Match header or entry etag attribute required

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys I'm following the example code as defined on this website: http://www.ibm.com/developerworks/opensource/library/x-phpgooglecontact/index.html I want to be able to integrate with my google apps account and play around with teh contacts. However I get this error whenever I try to run the modify… >>> More
javascript regex: match altered version of first match with only one expression

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there I'm writing a brush for Alex Gorbatchev's Syntax Highlighter to get highlighting for Smalltalk code. Now, consider the following Smalltalk code: aCollection do: [ :each | each shout ] I want to find the block argument ":each" and then match "each" every time it occurrs afterwards (for… >>> More