Please help resolve this

Closed
Posts
2
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 11, 2015
-
Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
-
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

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
can you explain with more details?
Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
243
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.
Posts
2
Registration date
Friday April 10, 2015
Status
Member
Last seen
April 11, 2015

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
Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
243
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.