array table lookup

  1. M

    Data filtered into other sheets

    Hi, I need some guidance on the following please; I would like to generate data in other spreadsheets based on information in a particular column also any new entries on the front sheet will be automatically updated in the relevant sheet that information relates to. All ideas welcome...
  2. L

    Want to return value from 2nd column based on match in 1 field with first column

    I'm working on a project in which I have 50 states + DC listed by 2-letter abbreviation, and want to return a value in another column that will be a non-unique number (some will duplicate in the second column.) Also need to do this same operation with first column (state) and third column...

Some videos you may like

This Week's Hot Topics