Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP using multiple columns
I have a data sheet that I am trying to put a weight factor at the end of
each row depending on 3 variable (3 columns) Is there a way using HLOOKUP to match data in muliple columns. Ex. Column 1 Column 2 Column 3 # of Employees Industry Code Payroll Frequency I have about 128 different weight factors depending on the different number of combinations the data in the above 3 columns contains. Any help would be greatly appreciated!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Multiple Columns | Excel Worksheet Functions | |||
Matching Multiple Columns | Excel Worksheet Functions | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) |