I need help trying to get a false return blank.

[Severno]

=INDEX('Master Store List_Final'!$C:$C,MATCH(Sheet1!O6,'Master Store List_Final'!$B:$B,0))

So I finally got this to work because I was so used to using VLOOKUP. The only problem is when the lookup is blank is comes back as N/A. I would like it to come back as as blank by using "". So i figured an IF statement would work but I am having trouble figuring out the IF statement if the above formula is a TRUE and the FALSE would read as ""

 

[Peter_SSs]

Well, as far as I can see both post 2 and post 3 do what you want. Here is my new sample data with both the mentioned formulas.
Are they the correct results for my sample data?
If so, but you are not getting the desired results with your data, then please review what I said last time

In that case perhaps we need some sample data (see XL2BB) to determine what is different about your data/setup to ours.

Severno.xlsm
	B	C
1
2	021	Store Name 1
3	022	Store Name 2
4	023	Store Name 3
Master Store List_Final

Severno.xlsm
	O
6	021
7	22
8	023
Sheet1

Severno.xlsm
	A	B
1	Post 2	Post 3
2	Store Name 1	Store Name 1
3
4	Store Name 3	Store Name 3
Sheet2

Cell Formulas
Range	Formula
A2:A4	A2	=IFNA(INDEX('Master Store List_Final'!$C:$C,MATCH(Sheet1!O6,'Master Store List_Final'!$B:$B,0)),"")
B2:B4	B2	=XLOOKUP(Sheet1!O6,'Master Store List_Final'!B:B,'Master Store List_Final'!C:C,"")

 

[Severno]

Well, as far as I can see both post 2 and post 3 do what you want. Here is my new sample data with both the mentioned formulas.
Are they the correct results for my sample data?

Thank you. I ended up using these formulas. I just copied the data I needed and I put them in a new sheet and everything seemed to work fine. Thanks again for your time and knowledge!

 

[Peter_SSs]

You're welcome.