Previous Topic Next Topic

Comparing values of 1 excel cell with column

Closed
Bhavin Kurwa - Feb 12, 2012 at 10:16 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 16, 2012 at 09:55 AM
Hello,
Please can you assist me with this excel formula?

In sheet 1 I have business rules specified in column A and all the requirements that exercise this business rule specified in column B.

In Sheet 2 I have the Requirements in details. Column A = Requirement Number and Column B = Requirement Detail.

I want to Run a formula in Sheet 2 such that Column C cells have the values of Business Rules exercised by the requirements in Column A.


Thank you in advance,
Bhavin Kurwa


Related:

1 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Feb 16, 2012 at 09:55 AM
Hi Bhavin,

What kind of data are we talking about?
Sheet1 Column A contains text?
Sheet1 Column B contains more text?
Sheet2 Column A contains numbers?
Sheet2 Column B contains text?

Now you want to put Sheet1 Column A data in Sheet2 Column C depending on the value in Sheet2 Column A.

What is the relation between Sheet1 Column A data and Sheet2 Column A data?

Am I warm or am I moving off track?

Maybe you can provide some rows (enough to make your point) of data and explain how you foresee the data in Sheet2 Column C to appear.

Best regards,
Trowa
0