vlookup()
 

To give you a feel for what I'm trying to do:

I have 1000+ different rows of commission rates. There are 7 criteria
which define each rate (criteria in A-G and rate in H). I have to link
each of these rates to corresponding cells in 4 different sheets.
However, I do not want to go back and forth between the commisions
table and the other 4 sheets. I want to be able to use vlookup or a
lookup type function to find the rate. Vlookup requires that the table
be in ascending order (otherwise use false). However, I do not think or
at least that I am aware of that I can sort the table in ascending
fashion for each criteria. There are bound to be descents. Does
anyone have any insight as to what I may be able to use?

Thanks in advane,

---
Isaac Maycotte


--
I Maycotte
------------------------------------------------------------------------
I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
View this thread: http://www.excelforum.com/showthread...hreadid=562872

vlookup()
 

Having now seen an example of your data it would appear that
concatination would work.

Insert a column between the criteria and the rates and enter the
formula
=CONCATINATE(A2,B2,C2,D2,E2,F2,G2)

copy this formula down your column and use this as the vlookup
criterion using FALSE to avoid sorting.