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

 

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

 

[Severno]

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

Thats is what I am looking for. We are to enter the number of a store in sheet 1 and on sheet 2 it will spit out the Name of the store. Some of these stores have zeros in the front so I formatted all cells to text. I am wondering if there is something else I can change because the formula looks right. The original formula I put up does work it just spits out those **** N/A lol