How to built a formula for the below scenario

[RahulNa]

I have sheet1 with headers L1, L2, L3

L1	L2	L3
Benefit Computation	Waiver	Waive invoice lines before invoice closure

Another sheet 2

L3	L1	L2
Waive invoice lines before invoice closure	Invoice Point Based Invoicing	Intermediate Invoice Generation
Waive invoice lines before invoice closure	Benefit Computation	Waiver

I want a formula in sheet 1 where L3 in sheet 1 should match with sheet 2 based on which it should compute L2 of sheet 1 with sheet2 and share a response if it matches as Yes.

 

[Rhodie72]

This is as clear as mud but here's something:

=IF(Sheet2!A2<>0,Sheet2!A2,"")

 

[RahulNa]

I may not have explained it well.

If the L3 values is matching with sheet 2 it should trigger the other formula that matches L2 value from sheet 2 to sheet1.

Basically, I want a formula where if my L3 value is matching with sheet 2 and then it should match with L3 value.

 

[Rhodie72]

"trigger the other" function in range("D1") "that matches L2 value from sheet 2 to sheet1"?
You are going to have to be very specific about what you want and where you want it. We are people instructing a computer which has no understanding. All I can do is take your clear instructions and turn them into VBA code or a formula that the computer processes as instructed to do.

I am looking at functions {IF, MATCH, VLOOKUP, XLOOKUP, LEFT, RIGHT, MID, OFFSET} among others.

Do you want this as a VBA script or as formulas?

PROs and CONs of each: VBA vs Formula
Can process everything accurately and extremely fast? Yes vs Maybe, depending on how many rows of data [More data = more time]
Can have multiple cases to coose from per cell relative to another cell? VBA=Yes vs Formula=With greeat difficulty and long formulas

So I understnad your question to look like this in a formula:

=IF(CONCATENATE(Sheet1!C2,Sheet1!B2,Sheet1!A2)=CONCATENATE(Sheet2!A3,Sheet2!C3,Sheet2!B3),Sheet2!A3,"")
(

 

[Rhodie72]

If you are just looking to copy data from one place to another and it is consistent in method then VBA is the way to go with it. If you define your ambition for the completyed task, we might be able to provide you with a solution to the problem beyond your own knowledge.