Something like VLOOKUP/INDEX/MATCH

[jwoww]

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

 

[jasonb75]

There are 2 ways of doing this (actually, there are a lot more but these are the simplest 2)

=XLOOKUP(J3,$EB$2:$EB$12,$EA$2:$EAE12,0)

Or, if you don't have the XLOOKUP function in your version of excel.

=IFERROR(INDEX($EA$2:$EAE12,MATCH(J3,$EB$2:$EB$12,0)),0)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Something like VLOOKUP/INDEX/MATCH
and

https://www.reddit.com/r/excel/comments/nnjr33

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.