Forum Discussion

Alex Gilbey's avatar
Alex Gilbey
Copper Contributor
Nov 15, 2018
Solved

Lookup formula using part of string

Hi All, Apologies if my question has been asked before. I have tried searching and found similar queries but none exactly matching what I need to do and I don't have the knowledge to make the necess...
excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Nov 15, 2018
    you can use wildcards in VLOOKUP like so:
    =VLOOKUP(A2&"*",B2:B100,2,FALSE)
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 15, 2018
you can use wildcards in VLOOKUP like so:
=VLOOKUP(A2&"*",B2:B100,2,FALSE)
  • Alex Gilbey's avatar
    Alex Gilbey
    Copper Contributor
    Nov 15, 2018

    Thanks Jan, very useful

Resources