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 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Apr 11, 2015 at 09:39 AM
Hello,

=IF(B1=Sheet2!A1,C1=Sheet2!B1)
i have a cell in sheet 1 need to write the price from sheet 2 when I put a certain text in sheet 1

3 replies

MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 10, 2015 at 06:38 PM
can you explain with more details?
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
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.
0
roukaf Posts 2 Registration date Friday April 10, 2015 Status Member Last seen April 11, 2015
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
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 252
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.
0