How to auto fill a column

Diego Casillas Zaragoza

Hello,

I have "Sheet 1" which we work from and "Sheet 2" which we mass upload into. What I want to do is when Im in Sheet 1 and I enter a production order number, I'd like it to go look in Sheet 2 shortages and put them in the comment section in Sheet 1. how can I do that?

Bassam Khalil

Hi @Diego Casillas Zaragoza

Hope you are fine, you can do that by using one of the following functions ( Vlookup, Index with Match )

Genevieve P.

Hi @Diego Casillas Zaragoza

To add on to @Bassam.M Khalil's good suggestion, if you need help building out these cross-sheet formulas, it would be helpful to see a screen capture of each sheet (with the sensitive data blocked out, or a dummy sheet with the same columns instead).

If you could provide this, along with detailing exactly what you want to be brought across, the Community would be happy to help! It may be an INDEX(MATCH formula, or INDEX(COLLECT (see this post) or it could be a JOIN(COLLECT (see this post), depending on the data you're looking to retrieve.

Cheers,

Genevieve