You can use a combination of INDEX and MATCH functions. For example...

=INDEX(Array,MATCH(LookupValue,LookupArray,MatchTy pe))

Hope this helps!

In article ,
gb_S49 wrote:

when using vlook, it always goes from the Left column to Right column. Is it
possible to use vlook to the left.
did that make sense?