Match look up Array from Vlookup.

**jrodri14** · 05-22-2010, 07:41 PM

hi!

I'm trying to get vlookup to give the match command which array to look in for the cell value. However, it seems that vlookup gives the array value in quotation marks (The error checker showed me this). How do I get it not to give me that output, but instead to reference the actual array in particular worksheet. Here is my function:

Please Login or Register  to view this content.

(I get #Value!)

Upon replacing the vlookup with the actual value array name:

Please Login or Register  to view this content.

it works fine.

Step by step formula evaluation shows:

Please Login or Register  to view this content.

And it says the next step will lead to an error.

Any help is appreciated.

**chrispulliam** · 05-22-2010, 08:27 PM

Not saying that I can help but I have found if you post a sample spreadsheet with your before and after data in separate sheets you tend to get a better response.

**jrodri14** · 05-23-2010, 12:43 AM

Sorry about that. I was wondering after I wrote if I SHOULD have included an example.

Anyways I figured it out

I'm using a nested vlookup function to direct the parent vlookup function to an array. I have the nested vlookup function looking up the cell with the name of the array. This only worked after I used the indirect() function on the nested vlookup function

Please Login or Register  to view this content.

It works fine now. That took hours to figure out.

Match look up Array from Vlookup.

LinkBack

Thread Tools

Rate This Thread

Display

Match look up Array from Vlookup.

Re: Match look up Array from Vlookup.

Re: Match look up Array from Vlookup.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions