Iferror(vlookup) query

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

You appear to have different Lookup Lists. It may be possible to use a helper column or other functionality to identify in which column D55 exists (if at all) and then knowing that single column the value in the adjacent column is easily found. However upload the workbook.

In G4, copied down:

=IFERROR(INDEX('Products List'!$C:$AY,MATCH(D4,INDEX('Products List'!$B:$AX,,MATCH(B4,'Products List'!$B$2:$AX$2,0)),0),MATCH(B4,'Products List'!$B$2:$AX$2,0)),"")

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

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