Index and Match error

[Steven811]

Hi All

I need to update my product list with new prices. It is using the information from a small list to populate a much larger list. I can get the formula to work on a small sample of the data but, when I try and get it work for real I get error messages saying the data is the wrong type.

=(INDEX($BQ$2:$BQ$3499,MATCH(BR2,$A$2:$A$86708,0)))

Enclosed workbook shows the problem. I have cut the list in half to get in under 1mb but, you can see the issue.

This is driving me nuts and if someone could help I would be very grateful.

Steven811

[JohnTopley]

I have no idea what you are trying to do:

AF001 is matched in row 13350 where column B has another formula .

MATCH(C13350,$A$2:$A$86708,1)) but column C entry is blank

????

[Glenn Kennedy]

Use this:

=IFERROR(INDEX($D$2:$D$3500,MATCH(C3,$A$2:$A$86708,0)),"Error")

You were searching in the wrong columns...

[sandy666]

I think you should read about MATCH() function first

and your A and C columns doesn't contain any similar values (or the same)

edit:
refresh thread required

[avk]

Try with this in "B2"

Please Login or Register  to view this content.

[AliGW]

refresh thread required

There is absolutely no need to start a new thread. Please continue here.

[sandy666]

I said refresh not fresh (by myself)

[AliGW]

Apologies. In that case, what do you mean?

[sandy666]

I should refresh thread before post

[AliGW]

Ah! I see.

[Steven811]

Thank you everyone for having a look.

I realised that I had things back to front after using the suggestion from avk

Top job

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.