Please help resolve this
Closed
roukaf
Posts
2
Registration date
Friday 10 April 2015
Status
Member
Last seen
11 April 2015
-
10 Apr 2015 à 12:51
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 11 Apr 2015 à 09:39
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Moderator Last seen 6 September 2024 - 11 Apr 2015 à 09:39
Related:
- Please help resolve this
- Davinci resolve 18 download - Download - Video editing
- Pluraleyes davinci resolve - Download - Video editing
- Resolve ip to hostname cmd - Guide
- One of your friends has locked the computer with a cmos password, preventing from booting, and forgot the password. what can you do to resolve this? - Guide
- Account temporarily unavailable. your account is currently unavailable due to a site issue. we expect this to be resolved shortly. please try again in a few minutes. - Facebook Forum
3 responses
MaxStart
Posts
338
Registration date
Tuesday 3 March 2015
Status
Moderator
Last seen
3 July 2015
69
10 Apr 2015 à 18:38
10 Apr 2015 à 18:38
can you explain with more details?
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
10 Apr 2015 à 22:36
10 Apr 2015 à 22:36
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 10 April 2015
Status
Member
Last seen
11 April 2015
11 Apr 2015 à 03:10
11 Apr 2015 à 03:10
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 24 July 2014
Status
Moderator
Last seen
6 September 2024
262
11 Apr 2015 à 09:39
11 Apr 2015 à 09:39
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.
