| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vookup related query
Hi
I have a column like this contained in cell a1 BY TRANSFER- R:SBINH09222318684 MAHAK MARKETING-- another column is like this in cell d1 SBINH09222318684 can i put a vlookup between this two. in such a way that formula should find the second value as lookup_value in cell a1. Can a combination of mid & vlookup will solve this ? pls help. thanks in advance. As I have to make a bank reco and the data specified in a1 is in such a way that I can not seperate that no from the whole list. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you add related cells in a sum? | Excel Discussion (Misc queries) | |||
| two related workfiles | Excel Discussion (Misc queries) | |||
| Require help related to Excel Query outer join problem | Excel Discussion (Misc queries) | |||
| Help create a IF statement to look to to seperate vookup data sour | Excel Worksheet Functions | |||
| Another "World Cup" related query | Excel Discussion (Misc queries) | |||
Threaded Mode
