ISnumber with Index/Match GoogleSheets

[shlomek12]

Can someone please help me, what is wrong here?

if(ISNUMBER(A68),INDEX('Pricing & Availability'!A:E,match(A68*1,'Pricing & Availability'!A:A,0),2),INDEX('Pricing & Availability'!A:E,match(A68,'Pricing & Availability'!A:A,0),2))

I am getting the massage:

"Error Did not find value '9178891612' in MATCH evaluation."

A68 is indeed a number


Thanks in advance

 

[Fluff]

Re: ISnumber with Index/Match

Will that work if A:A is text?

If it's numbers stored as text, then yes.
Which from the OP I thought is what was needed, but now realise is wrong.

 

[Fluff]

Re: ISnumber with Index/Match

Google Sheet

As this is an Excel forum it would help if you let people know you are using something else.
I have moved you thread to the correct section & changed the title.

 

[shlomek12]

Re: ISnumber with Index/Match

Is this in Excel or some other spreadsheet software?

How can I check this out in Google Sheet?

 

[shlomek12]

Re: ISnumber with Index/Match

As this is an Excel forum it would help if you let people know you are using something else.
I have moved you thread to the correct section & changed the title.

OK Thanks, I did now know it will be a different which app I am using

But anyway I need it urgent, I hope someone can help me

 

[Fluff]

Re: ISnumber with Index/Match

You haven't answered gaz_chops question in post#9

 

[shlomek12]

Re: ISnumber with Index/Match

It Says "Automatic" unter format menu

So I don't know for sure

Is there a way to check it?

 

[Fluff]

Re: ISnumber with Index/Match

Find this value 9178891612 in the Pricing & Availability sheet & then use
=istext(a1)
Change A1 to the cell containing the number. What does it say?

 

[shlomek12]

Re: ISnumber with Index/Match

Find this value 9178891612 in the Pricing & Availability sheet & then use
=istext(a1)
Change A1 to the cell containing the number. What does it say?

FALSE

Here is an image:https://nimb.ws/g4cCsj

 

[Fluff]

Re: ISnumber with Index/Match

In that case what happens if you try
INDEX('Pricing & Availability'!A:E,match(A68,'Pricing & Availability'!A:A,0),2)

 

[shlomek12]

Re: ISnumber with Index/Match

In that case what happens if you try
INDEX('Pricing & Availability'!A:E,match(A68,'Pricing & Availability'!A:A,0),2)

Did not find value '9178891612' in MATCH evaluation.