Trying to do a vlookup against a list

[Magnatolia]

Hi everyone,

I'm looking to export my bank transaction statement into excel and want to create a list of snippets with categories so I can auto categorise some ofm y statements.

I thought maybe a vlookup as an array, but this didn't work {=IFERROR(VLOOKUP("*"&$K$1:$L$50&"*",$B$3:$B$500,2,FALSE),"")}

Any thoughts on what I could do?

Thanks!

 

[Scott T]

The lookup value of vlookup can never be an array.

Your table array is only one column B3:B500 but you are trying to look into the second column.

If you post an example of your data then someone should be able to help with a formula.