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…