ALL the different lookups you need to know before you start your corporate job 🤝 Lookups help you pull related data from one table into another using a shared value 🔍VLOOKUP Searches for a value in the left-most column and returns related data from the same row, but only from columns to the right. Pros: easy to learn, widely recognized, works in older Excel Cons: can’t look left, breaks if columns move, high risk of silent errors Best for: small, stable tables 🔍HLOOKUP Same logic as VLOOKUP,