Linking cells based on value

jockovic

New Member
Joined
Dec 24, 2017
Messages
2
I need some help... I want enter value in one cell and link it with cell in another tab... for example if I enter in a1 25 i want to cell b2 is linked with a25 in another tab.... and so on... just to link cells based on what I enter
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
if you go to your second sheet and enter = then navigate to the sheet you want the value from, select that then press enter
 
Upvote 0
I think I didn't explained well... In sheet2 i have names of products and in sheet one I want wheen I type number of the cell in shhet two automatically link me with cell in sheet2 and display value from that cell.... I type 225 in a1 i would like value in b2 from second sheet
 
Upvote 0

Forum statistics

Threads
1,214,887
Messages
6,122,095
Members
449,064
Latest member
Danger_SF

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top