Something like VLOOKUP/INDEX/MATCH

[jman0502]

I have tried looking everywhere and cant find anything that works.

Basically this is all of what i need my formula to do:

Example:
-in L3, i want it to check the EB column for the same phrase/value as J3. If it finds it in the EB column, in L3 place the corresponding value of EA column if it finds J3 phrase in EB column
-If EB column doesn't contain J3, rather that return #N/A, I want it to return either nothing or a zero but i still need the same line in the N column to be able to calculate as well as the L column needs to be able to count the total value of all columN L

In the attached image, basically i want the L column to read the following (from L3 down)
-12
-8
-(blank value)
-(blank value)
-7
-5
-(blank value)
-6
-(blank value)
-(blank value)
-(blank value)
-4
-(blank value)
-(blank value)

Hope this makes sense and someone is able to give me some suggestions

Capture.PNG

[kvsrinivasamurthy]

Try this In L3

=IFERROR(Index($EA$3:$EA$12,match($J3,$EB$3:$EB$12,0)),"")

Pl read the yellow banner on top of this page.

[Limor_OP]

Hi
please upload your sample in excel.
Look at the yellow banner at the top of the page for instructions.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)