VLOOKUP with conditions

[sburkhar]

Is it possible to do a Vlookup where it only looks at the first 9 digits of a number? For example in the list below, the only difference is the last two digits. I need the answer returned if anything matches the first 9 digits.

180G0806590
180G08065F0
180G08065F7
180G08065H1
180G08065J5
180G08065M3

 

[MrKowz]

You'll need to do an INDEX/MATCH array-entered formula instead. What ranges are you dealing with (ie: what range are you looking in for the match, what range are you wanting to return, and what range holds the value that you are looking for)

 

[MisterBate5]

Use left("string",9)&"*" as your first parameter to vlookup. Even with exact match, it finds first row where the first 9 digits match.

 

[sburkhar]

I think that's working. thanks!