IFERROR INDEX & MATCH results in Blank

What am I doing wrong?!

I'm trying to use the following to look at H4 and return the value in DATA REVISED B:B, if there is no value, return the whats in F4

It returns the value in 'DATA REVISED B:B, but I just get a blank cell if there's no data. I've tried a few different formulas, VLOOKUPS, IFs, but nothing works correctly

=IFERROR(INDEX('DATA REVISED'!B:B,MATCH(H4,'DATA REVISED'!A:A,0)),F4)

Thanks in advance!

That should work. Can you attached the file (see yellow banner at top of page)

Please see attachment

I'm assuming we're looking at the formula in cell H4, correct. It's confusing because it doesn't look like your file matches your post. In your post you have this formula:
=IFERROR(INDEX('DATA REVISED'!B:B,MATCH(H4,'DATA REVISED'!A:A,0)),F4)

but in your file, the formula is:
=IFERROR(INDEX('DATA REVISED'!A:A,MATCH($B4,'DATA REVISED'!C:C,0)),0)

In one your index array is column B, but in the other it's column A. and it's matching on column A, not C. Then in your post you want to show what's in F4, but in you file you want to show 0.

My guess is if you change the 0 to F4, you should get what you want???

Sorry it's column I on tab - Venue that I'm having issues with

It looks like it's doing what you are wanting. It's bringing back the value under Column B by going down the number of rows where what's in H4 matches whats in col A in Sheet Data Revised.

So currently in cell I5 it says - get me the value in Column B by going down the same number of cells that you go down to match "site establishment" in column A.
So "Site Establishment" is 2 rows down column A, and the cell 2 rows down Column B is blank, and so cell I5 is blank.
Now, if you change the value in H4 to "ABC", it won't find it, and therefore there's an error so it shows what's in F4, which is 1000.

As per my original post, "if there is no value, return the whats in F4"

As there is no associated value against 'Site Establishment' in tab - DATA REVISED, I want it to return the value in F4 i.e. $1000

I assume that if you don't find a match, that you also want to show what's in F4. If that's the case, try this:

=IFERROR(IF(INDEX('DATA REVISED'!B:B,MATCH(H4,'DATA REVISED'!A:A,0))="",F4,INDEX('DATA REVISED'!B:B,MATCH(H4,'DATA REVISED'!A:A,0))),F4)

That's it! Amazing, thank you. I was going nuts trying to figure it out!