Vlookup / Match max min number on different worksheet
- by Dan
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