Entering value for column at once, displaying in all sheets

[Solved/Closed]
Report
Posts
1
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 21, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
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.