Vlookup Help

Robert S Fike

I want to pull data from sheet A (LNH Master Sheet) in a specific column (Closing Date) and move it to sheet B(Job Progress), column (Closing Date). Both sheets have as the primary column named Job Number. I want the data from sheet A to copy to the same row with the same job number. I am stumped. Any help

Andrée Starå

 @Robert S Fike

I hope you're well and safe!

I'd recommend using an INDEX/MATCH formula structure.

Do you have a unique ID that we can use to connect the sheets?

More info:

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Robert S Fike

Excellent! This is the structure! Make sense?

=INDEX({ColumnWithTheValueYouWantToShow}, 
MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0)

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

 @Robert S Fike

I hope you're well and safe!

I'd recommend using an INDEX/MATCH formula structure.

Do you have a unique ID that we can use to connect the sheets?

More info:

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Robert S Fike

Yes. Our primary column is our job number. Ex 00-82567

Andrée Starå

@Robert S Fike

Excellent! This is the structure! Make sense?

=INDEX({ColumnWithTheValueYouWantToShow}, 
MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0)

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Robert S Fike

How do i work this between 2 sheets? I want on sheet A data from a specific cell for a specific cell on sheet B, where they are tied together with the same job number.

Sheet - A

Job # - 00-11111

Column - Closing Date

I want the value to end up on Sheet B.

Sheet - B

Job # - 00-11111

Column - Closing Date.

Andrée Starå

@Robert S Fike

Try something like this. Add the formula in the second sheet, the Date Column, and create the cross-sheet references. Do you know how to make them?

=INDEX({Sheet A Closing Date Column}, 
MATCH([Job #]@row,{Sheet A Job # Column}, 0)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Robert S Fike

I have not used cross reference but i can look it up. I know i have watched a video, i think. I really appreciate your help.

Robert S Fike

=INDEX({{LNH MASTER SHEET Range 1}, MATCH([Job Number]@row, {{LNH MASTER SHEET Range 2}, 0))

Gives me #INVALID REF error

Robert S Fike

NVMD. I fixed the issue. Thanks for all the help. You rock.

Andrée Starå

@Robert S Fike

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Robert S Fike

After working with the sheets, i realized that linking cells does not update as things change on a row. So i used this formula and i get #NO MATCH.

=INDEX({Test Copy row Range 1}, MATCH[Job Number]@row, {Test Copy row, link cells Range 2}, 0))

Trying to use the job number to pull the address over to the 2nd sheet

Robert S Fike

Sorry again. I went back over all you said and figured this one out as well.

Andrée Starå

@Robert S Fike

Excellent!

Glad you figured it out!