Welcome!

Vlookup formulae linkage across sheet

Hello, I have been trying to link my source sheet(A) with another sheet (B) as B is the base of my dashboard wherein I had inserted all the formulae for dashboard creation to display real time changes.

How do I link my sheet B with Sheet A ?

As all the changes are being made in sheet A, I want those changes to be transported to Sheet B so that dashboard changes can be seen as soon as a change is made in sheet (A).

Sheet A-->Sheet B-->Dashboard

Find more posts tagged with

Comments

Andrée Starå

Hi Alisha,

You could use cell-linking to achieve this.

Please see attached link/screenshot.

https://help.smartsheet.com/articles/861579-cell-linking

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Paul Newcome

Cell linking will work pretty well, but to use VLOOKUP (or any other formula for that matter) you have to use cross sheet references (frequently seen in the community as "x-sheet references").

The article below should help to explain these. If you still have further questions, don't hesitate to ask.

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets?frame=0&nav=1

J. Craig Williams

Drawbacks to VLOOKUP:

1. Column order on source sheet may mess your formula results.

2. Selecting the larger portions of the sheet to reference is a waste of processing power and may get to closer to or over the number of cells you can reference.

INDEX(..., MATCH(...)) is a better solution, in nearly all cases.

Craig

Paul Newcome

INDEX(..., MATCH(...)) is a better solution, in nearly all cases.

I agree. VLOOKUP is just more often used in Smartsheet examples, so I referenced that (in this case) simply for ease of understanding when reading Smartsheet articles.

I have slowly but surely started moving away from VLOOKUP. I haven't had any problems with it (yet), but I love the flexibility of INDEX/MATCH.

J. Craig Williams

LOOKUP (renamed VLOOKUP) predates INDEX(...,MATCH()), which I believe may be the reason for the examples. Also that people may be more familiar from it in Excel.

I held off as long as I could using it in examples because I thought newbies might not get it as easily. Then I just decided they were better off in the deep-end.

Craig

Paul Newcome

Better off in the deep end... That's my manager's training style. Throw you in and MAKE you learn how to swim. Hahahaha

J. Craig Williams

LOL.

I do as much hand-holding as the swimmer needs or requests. Sometimes I get pushed away, but I still won't let them drown.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Using single-sign-on with external partners
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Anyone have the link to register for the Core Product Exam without the Learning Pass.
Cant find this anywhere