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

That suggests that the value in A68 is text not a number.
Not knowing GoogleSheets functions makes it difficult, but you could try
=IF(ISERROR(A68*1),INDEX('Pricing & Availability'!A:E,MATCH(A68,'Pricing & Availability'!A:A,0),2),INDEX('Pricing & Availability'!A:E,MATCH(A68*1,'Pricing & Availability'!A:A,0),2))

 

[shlomek12]

Re: ISnumber with Index/Match

That suggests that the value in A68 is text not a number.
Not knowing GoogleSheets functions makes it difficult, but you could try
=IF(ISERROR(A68*1),INDEX('Pricing & Availability'!A:E,MATCH(A68,'Pricing & Availability'!A:A,0),2),INDEX('Pricing & Availability'!A:E,MATCH(A68*1,'Pricing & Availability'!A:A,0),2))

Tanks you 10000000000000000000000000000000 times, you can not image how big you helped me

 

[Fluff]

Re: ISnumber with Index/Match

Glad it worked & thanks for the feedback