Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Can you vlook up two sheets?

Nakul Tyagi

Nakul Tyagi ✭

10/04/16 edited 12/09/19 in Archived 2016 Posts

I have related data on two seperate sheets. Like excel - I want to establish v look up for one sheet to update when other is updated with master information

Tags:

Integrations

0 ·

Comments

Brett Evans ✭✭✭✭✭✭

10/04/16

See Kennedy's answer...
https://community.smartsheet.com/discussion/vlookup-function?page=7

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…
Can someone please help me with a COUNTIFS formula?
I can't seem to get this formula to calculate any results other than 0 COUNTIFS({11.08.2024- Labor Allocations for Smartshe ES}, [Expense Specialist]@row, {11.08.2024- Labor Allocations for Smartshe FU}, OR(@cell = "410101", @cell = "41201", @cell = "410202", @cell = "410203". This is only a part of a larger formula.