srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
I need to know how can I use a wild card in following formula.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=VLOOKUP(R959,Table!$A$2:$F$141,6,FALSE)<o></o>
Or<o></o>
=LOOKUP(9.99999999999999E+307,SEARCH(R959,Table!$A$1:$A$147),Table!$F$1:$F$147)<o></o>
<o> </o>
Lookup value in column R is shorter than lookup table in column A on sheet “Table”.<o></o>
<o> </o>
Therefore I need to put &”*” on R value.<o></o>
<o> </o>
Thanks<o></o>
=VLOOKUP(R959,Table!$A$2:$F$141,6,FALSE)<o></o>
Or<o></o>
=LOOKUP(9.99999999999999E+307,SEARCH(R959,Table!$A$1:$A$147),Table!$F$1:$F$147)<o></o>
<o> </o>
Lookup value in column R is shorter than lookup table in column A on sheet “Table”.<o></o>
<o> </o>
Therefore I need to put &”*” on R value.<o></o>
<o> </o>
Thanks<o></o>