I am trying to use v-lookup to search part of the text in a cell and have the information displayed.
The formula is entered in cell is J2 in sheet2 and contains urls like the ones listed below
< i.e I would like to match ACCT to column N in spreadsheet 2 >
The array looks like this which is on spreadsheet sheet 2
column N column O
1. acct Account
2. estm Estatement
3. logon Logon
Here is the formula I attempted to use
= Vlookup ( "*" & H1 & "*", sheet3!N1:011,2,False
Nothing happen, is there a way to do a vlookup by referencing part of a text in a cell.