Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup using range with catenated first and second column values
Hi,
I have a vlookup fuction - e.g. (VLOOKUP($C$3,_Map1,8,FALSE) - that needs to lookup the value (in the 8th position) in $C$3 (current sheet) that is equal to the concatenated value of the first and second column values in my range, "_Map1", which is contained on my "Summary" sheet. For example, my value for $C$3 is "Lysell, Kent(17)". I need to lookup up the particular row in my range where column c value is "Lysell, Kent" and the adjacent column d value is "17" ("17" in column d doesn't have "()" around it. I've seen other solutions on this DG, but these are using the "match" function. Is this solution adaptable to my "vlookup" function? Or should I change all my formulas to the "match" fn? Thanks in advance! -- Kent Lysell Financial Consultant Ottawa, Ontario W: 613.943.9098 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
index, match lookup using catenated values not working | Excel Worksheet Functions | |||
Programatically Naming Worksheets (using catenated values) | Excel Programming | |||
Vlookup with a range of values | Excel Discussion (Misc queries) |