| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using vlookup for words w/different indentation
Hi,
I'm trying figure out a way to use a vlookup function when the word in the table is the same but indented differently. For instance, you're looking for the price of an 'apple' but the word 'apple' in the table is actually written ' apple' with 4 spaces in front of the word. I was trying to use the 'Right' function but the number of letters my vary. Thanks for your inputs. |
| 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 | |||
Threaded Mode
