Help with V-lookup

Tzippy · 10/06/22

I have two sheets with the following 2 columns.

column 1 - HRC code

column 2 - status

The HRC code will always match on both sheets but the status may be different. Sheet 1 will have the most current status but sheet 2 may have old information. I want the vlookup from sheet 2 to find the hrc code on sheet 1 and automatically update the status according to the status listed on sheet 1. Is that possible?

Michael Culley · 10/06/22

Seems possible to me. Is the issue you're having the NOMATCH error?

Tzippy · 10/07/22

@Michael Culley

No, in general I wasn't able to figure out how to return the value of the cell IF it doesn't match. So just ignore the nomatch. I kind of need help from scratch.

Andrée Starå · 10/07/22

Hi @Tzippy

I hope you're well and safe!

How is the Status on sheet two filled in? Is it a formula or a manual input?

Be safe, and have a fantastic weekend!

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!

Michael Culley · 10/07/22

Assuming that the status is manually entered on one sheet, I feel like you're doing the formula correctly but maybe your range isn't correct when you refer to the other sheet. Make sure you are selecting both columns in your reference.

Tzippy · 10/20/22

https://community.smartsheet.com/discussion/comment/346415#Comment_346415

@Andrée Starå

Manual input

Help with V-lookup

Answers

Help Article Resources

Categories