Microsoft Excel 2007

Question

Hi friends,

Every month I prepare a measurement sheet of various structure which contains various iron or steel material. I always face a problem for their unit weight. I have to enter them manually. Some measurement sheets are very lengthy as contains 700-800 rows.

So is there any way which save my time to enter unit weight? I attach a screenshot of a measurement sheet.

Regards,

Rahul

Answer 1

If you have an excel worksheet with a list of the unit weights against the Section code then you can use Vlookup function to insert the unit weights.

See the following link for more information on Vlookup formula

https://support.office.com/en-us/article/Look-up-values-with-VLOOKUP-INDEX-or-MATCH-68297403-7C3C-4150-9E3C-4D348188976B

Your table for the lookup should be something like the following. It can be on a separate worksheet.

Your vlookup formula will be like the following for cell E2 of your screen shot. Note that the lookup table is on a different worksheet and also note that the Table Array for the lookup is in absolute format (with the $ signs)

=VLOOKUP(A2,Sheet2!$A$2:$B$9,2,FALSE)

I also note that you have a different value in cell E15 that does not match the same section descriptions on the previous rows.

I would also suggest that you use list type data validation and for your column A and use the same list in column A as your list of Sections and Unit weights and that way you should never have a mismatch due to typos.

Feel free to get back to me if still having problems.

Answer 2

Is it column F you refer to?

And is this derived from D & E?

Answer 3

Yes I have such kind of excel sheet.

Thanks for your reply.

I will try this.

Answer 4

I am refer to column E and it is standard unit weight of respective section written on column A.

Column F is derived from column B,C,D & E.