Entering value for column at once, displaying in all sheets

Solved/Closed
ziauddinm Posts 1 Registration date Wednesday March 20, 2013 Status Member Last seen March 21, 2013 - Mar 20, 2013 at 03:16 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 20, 2013 at 05:23 PM
Hello,
I have a workbook with multiple sheets(1,2,3) , each sheet has list of items randomly placed, the same items are repeated in other sheets randomly , i want to give value to a particular item in Sheet 1 in column in front of item & the same should appear for all the identical items in all work sheets.

Sheet 1 Sheet 2 Sheet 3
A B A B A B
1 Apple 10 1 Rice 1 Onion
2 Orange 22 2 Grapes 2 Rice
3 Grapes 55 3 Onion 3 Orange
4 Onion 12 4 Apple 4 Grapes
5 Rice 88 5 Orange 5 Apple

When i give value in Sheet 1 for Apple as 10 same should appear in Sheet 2 & Sheet 3. Help pls


1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 20, 2013 at 05:23 PM
Hi ziauddinm,

You can use Microsoft Excel's VLOOKUP() Worksheet Function to lookup the value of a particular item from other sheets. Please check the below mentioned link for step by step instructions on how to use VLOOKUP() Worksheet Function:

https://ccm.net/faq/12503-how-to-use-the-vlookup-function-on-excel

Please revert for clarification.
0