Help me fix my excel formula please

[Jyggalag]

Hi all,

I currently have this formula:

The formula is supposed to look at the values for the company (column B) and the topic (column F) and then based on the value in column F, it will look at the sheet with the same name and find the values here:

I likewise have a sheet with the same name as cell F7:

Then in this sheet I have my values:

I have the company name in cell A7 here and the information I want to pull in can be found in column E.

Even after updating the formula above to E3:E75 (range of values in this sheet):

It still does not work and returns a blank cell, even though I do have a value there!

Any idea why? I have used this exact same formula before and it does work in my other sheet. I cannot figure out why Please help me!

@Fluff would appreciate you a lot especially

Kind regards,

Jyggalag

 

[KRice]

I created a small working sample:

MrExcel_20220608.xlsx
	B	C	D	E	F	G
7	Active Company				Annual Summary 2022	222
Sheet3

Cell Formulas
Range	Formula
G7	G7	=IF($B7="","",IFERROR(INDEX(INDIRECT("'"&$F7&"'!$B$3:$B$75"),MATCH(1,(INDIRECT("'"&$F7&"'!$A$3:$A$75")=$B7)*(INDIRECT("'"&$F7&"'!$C$3:$C$75")=$F7),0)),""))

MrExcel_20220608.xlsx
	A	B	C
2	Company
3	Acme	111
4	Active Company	222	Annual Summary 2022
5	Beta	333
6	Delta	444
Annual Summary 2022

...and there seems to be no issue with the formula. Have you carefully checked the single and double quotes? Alternatively, try my formula since it works in my test. And if that doesn't work, I would investigate where there is a known match to determine if there are extra/unwanted characters that are causing the problem. Perhaps check the length of the text string to determine if it matches a count of the visible characters/spaces.