# INDEX MATCH with Final Value Return Change

#### Morey

##### New Member
I agree with Fluff in that case. Add a sheet with a table of what outcomes should lead to what outcomes and do something like;
IFERROR(VLOOKUP(INDEX(…),
,2,0),"")

Ross,

Below is the formula (return value & lookup table) that I'm using but, it returns a 0. I noticed in your suggestion you use VLOOKUP and INDEX. Is it possible to mix both of them?

Possible to do something more like this? Currently, returns #VALUE .

Code:
``=IF(VLOOKUP(A2,'PR Report'!C:Z,19,0),"",(VLOOKUP(K2,List!E:F,2,0)))``

Morey

Last edited:

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Morey

##### New Member
Possible to do something more like this? Locked out of editing above message. Forum posting is glitched in IE. Please, ignore above.

Code:
``=IFERROR(VLOOKUP(INDEX('PR Report'!U:U,MATCH(A3&B3,'PR Report'!C:C&'PR Report'!E:E,0),"",(VLOOKUP(K2,List!E:F,2,0)))``
Morey

Last edited:

#### Morey

##### New Member
Hello All,

Formula/Array below did the trick.

Code:
``=IFNA(INDEX(List!F:F,MATCH(INDEX('Report'!\$U\$1:\$U\$5000,MATCH(A2&B2,'Report'!\$C\$1:\$C\$5000&'Report'!\$E\$1:\$E\$5000,0)),List!E:E,0)),"")``

Regards,

Morey

1,101,817
Messages
5,483,080
Members
407,377
Latest member
JennaWashburn

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...