VLOOKUP separate sheets

Bobby1
Bobby1 ✭✭✭✭
in Formulas and Functions

I would like reference sheet A zip code with zip codes in Sheet B, and when there is a match change a specific column status in sheet B

image.png
image.png

sheet B status

image.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Bobby1
    Bobby1 ✭✭✭✭

    also would it be possible to have 3 different sheets with different zipcodes that can vlookup on the the 4th sheet and changed the status in the 4th sheet

    · Share on FacebookShare on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    To make sure I am clear... You want a formula on Sheet B that will adjust the FQHC Type if the zipcode is found on Sheet A, or are you pulling the FQHC Type from Sheet A based on the zipcode in Sheet B?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!