Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup 'Like' values???
I have two s/sheets; one has many rows of data and I shall call thi
datasheet. The other is lookup table containing a column with 30 or s values. Here is my problem: I would like to be able to define a range consisting of the values i one of the columns from the datasheet (which I can manage) and the perform some kind of lookup/match/index to the lookup table. So what' the problem? Seems straightforward enough? The problem is that the values in the lookup table are partial values For example, a value in the datasheet will be 'XPBARC' but th 'matching' value in the lookup table will just be 'XPBA'! Now, courtes of Mr. Walkenbach, I have a user-defined function called ISLIKE whic some of you may be familiar with? But although this works on comparin two cell values I would prefer not to create a couple of loopin structures to examine the values in each s/sheet (I also can't do i anyway! ;-)) but would prefer, if possible, to use a lookup, o similar, which should be quicker also? So, if anybody could help I would be extremely grateful indeed! Many thanks, Adria -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i wish to lookup values in column A, & add adjacent values in colu | Excel Discussion (Misc queries) | |||
Lookup with two lookup values | Excel Discussion (Misc queries) | |||
How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
Advanced Lookup (lookup for 2 values) | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |