Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |