Forum Discussion
lautio
Sep 13, 2021Copper Contributor
Easy one
I have an easy one for you experts out there. I have sample worksheet attached, the actual has thousands of rows. I would like to be able to enter any number from Sheet 1 column A on Sheet 2 column A...
HansVogelaar
Sep 13, 2021MVP
You can use VLOOKUP for this, combined with IFERROR to suppress #N/A errors if you enter a value that doesn't occur on Sheet1. See the attached version.