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,"")

 

[Coyotex3]

Maybe wrapping your formula around the IFNA function as such:

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

 

[Peter_SSs]

Another option

=XLOOKUP(Sheet1!O6,'Master Store List_Final'!B:B,'Master Store List_Final'!C:C,"")

BTW, what is the name of the sheet that this formula is on?

 

[Severno]

Maybe wrapping your formula around the IFNA function as such:

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

Well, I wasn't even thinking of this and I was hopeful but it didn't work.

 

[Severno]

Another option

=XLOOKUP(Sheet1!O6,'Master Store List_Final'!B:B,'Master Store List_Final'!C:C,"")

BTW, what is the name of the sheet that this formula is on?

I'm writing it on sheet2. I there are no official names yet I am just trying to get the formula to work first.

 

[Severno]

I'm writing it on sheet2. I there are no official names yet I am just trying to get the formula to work first.

I'm going to try these at my house a little later. I always have a hard time on my work PC. Thank you and I will let you know if it works.

 

[Peter_SSs]

I'm writing it on sheet2.

Thanks for that. I thought that it may have been on Sheet1 (used in the formula). If that was the case i was going to recommend a change to the formula.

 

[Severno]

Thanks for that. I thought that it may have been on Sheet1 (used in the formula). If that was the case i was going to recommend a change to the formula.

So far both of these suggestions didn't work. I'm surprised because it's seems so simple and both seem like they would.

 

[Peter_SSs]

So far both of these suggestions didn't work.

In that case perhaps we need some sample data (see XL2BB) to determine what is different about your data/setup to ours.
Here is mine. Do I have incorrect set-up and/or incorrect results?

Severno.xlsm
	B	C
1
2	a	22
3	c	33
4	d	44
5
Master Store List_Final

Severno.xlsm
	O
6	a
7	b
8	c
Sheet1

Severno.xlsm
	B
1	22
2
3	33
Sheet2

Cell Formulas
Range	Formula
B1:B3	B1	=XLOOKUP(Sheet1!O6,'Master Store List_Final'!B:B,'Master Store List_Final'!C:C,"")