Google Sheets - VLOOKUP to the Left!

VLOOKUP is a great function, but what if the data you want to return isn't to the right of the search key? Learn the tricks for getting it to work.

Learn more from Prolific Oaktree:

#googlesheets #spreadsheets #vlookup

[kelsyfish]

This is exactly what I was looking for! Thank you so much! 🙏🏻

[Flauntmydesign]

Thanks! So simple! Works as an array formula too!

[rodtompkins]

A perfect tutorial and the only one I needed! I used it within an array formula in a form response sheet. Thank you!!!

[RealPilot]

Really so smart, simple and useful! Thanks.

[jiju]

very well explained. succinct. and i liked the f4 pro tip, I didnt know that. Thanks alot :)

[MichaelDaniels]

Awesome! Thank you for this Array formula solution!!! I always thought we had to do an index and match. Thanks

[markdandridge]

Thank you so very much for the perfect explanation.

[adityabarodia]

Nice google sheet doing Sir👍..it helps us a lot

[AdrianMartinez-lyle]

hahahah such an amazing solution, thanks!!

[platinumcreditplus]

HI can you help me with my google sheets
what formula should I use to capture the data in other sheets using a unique id
ex there's a double entry in another sheet the 1st entry did not have a specific value but the 2nd entry with the same id have data if I use vlook up the only it captures is the 1st entry

[myalternatelife]

Say you want to search using Employee Name, how do you go about this? When I tried, I got the error couldn't find the employee name when it's clearly there.

[RabaShibaRabaSha]

How would you return multiple results back if they all shared the same "emp_id" and but also you needed to lookup to the left.

[tomsawkins]

well I`LL be - well done. i have wondered if this was possible.

[jinsakai]

Thanks. Anyone know how to fix a range if you're using a chromebook *without naming that range*?

[goldcarps]

Does this methodology works for excel?

[msexcelgooglesheet]

Awesome but quite different and difficult from MS excel vlookup.

[morrisonhannah]

Thank you, this was really helpful!! Clearly explained

[anandtupe]

और google search results को भी मान गये, बेवजह quality search result नही देता google