Hello everyone
i have data master with standard structured such as "Street XXX", but i have to lookup with various data form, like "St XXX".
it's okay if only few data, but it will be a problem if more than 1000 data.
some case, i useon lookup value for vlookup, but we can't change to:=vlookup("*(criteria)*",...is there any other way to lookup not standard data with multiple criteria?=Vlookup("*A1*",....)
thanks
Bookmarks