Please help resolve this
Closed
roukaf
Posts
2
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 11, 2015
-
Apr 10, 2015 at 12:51 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 11, 2015 at 09:39 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Apr 11, 2015 at 09:39 AM
Related:
- Please help resolve this
- Davinci resolve free - Download - Video editing
- Davinci resolve disk speed test - Download - Diagnosis and monitoring
3 responses
MaxStart
Posts
339
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 10, 2015 at 06:38 PM
Apr 10, 2015 at 06:38 PM
can you explain with more details?
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Apr 10, 2015 at 10:36 PM
Apr 10, 2015 at 10:36 PM
Hello Roukaf,
If I understand your request correctly, you are saying that if you place a value in B1 on Sheet 1 that equals a value in A1 on Sheet 2, then you want the currency value in B1 on Sheet 2 placed in C1 on Sheet 1. If this is so, then this formula, placed in C1 on Sheet 1, may do the task for you:-
=IF(B1=Sheet2!A1,Sheet2!B1,"")
If it is not what you require, then please do as MaxStart asks and supply us with more information, preferably with a sample of your work book. You can upload a sample using a free file sharing site such as DropBox or ge.tt.
Cheerio,
vcoolio.
If I understand your request correctly, you are saying that if you place a value in B1 on Sheet 1 that equals a value in A1 on Sheet 2, then you want the currency value in B1 on Sheet 2 placed in C1 on Sheet 1. If this is so, then this formula, placed in C1 on Sheet 1, may do the task for you:-
=IF(B1=Sheet2!A1,Sheet2!B1,"")
If it is not what you require, then please do as MaxStart asks and supply us with more information, preferably with a sample of your work book. You can upload a sample using a free file sharing site such as DropBox or ge.tt.
Cheerio,
vcoolio.
roukaf
Posts
2
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 11, 2015
Apr 11, 2015 at 03:10 AM
Apr 11, 2015 at 03:10 AM
sorry
I want to write item in a cell consider(Sheet 1) A1 then automatically in cell B2 the item price written while I want to put in (sheet 2) the items and prices in a table like ( Items in column start from A1 in sheet 2 and prices in column start from B2
I want to write item in a cell consider(Sheet 1) A1 then automatically in cell B2 the item price written while I want to put in (sheet 2) the items and prices in a table like ( Items in column start from A1 in sheet 2 and prices in column start from B2
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Apr 11, 2015 at 09:39 AM
Apr 11, 2015 at 09:39 AM
Hello Roukaf,
Please supply a sample so that we can see exactly what you would like done. Someone should then be able to help you.
Cheerio,
vcoolio.
Please supply a sample so that we can see exactly what you would like done. Someone should then be able to help you.
Cheerio,
vcoolio.
