"Cntrl+F" Type Function for Range of Values?

**webb99** · 07-12-2010, 10:51 PM

I have a column of numbers on one tab, and an entire table of numbers on another tab. I need a formula that will allow me to retrieve numbers in the table that correspond to the numbers in my column (i.e., a sort of "vlookup" that allows you to pull data from an entire table or array, vs. just a single column). I can do this manually with "cntrl+f", but there are hundreds of cells, and this is quite painstaking. Any ideas on this one? I couldn't get the "index/match" system to work, as the table on my second tab has over 200 columns in it.

**JBeaucaire** · 07-12-2010, 11:42 PM

Post a sample workbook showing a good set of data and a mockup of the desired results you're trying to achieve.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

**webb99** · 07-13-2010, 10:06 AM

Here you are, sir. Does this help clarify my issue?

**JBeaucaire** · 07-13-2010, 11:49 AM

No, I don't see how the column C values relate to the second sheet. Can you give some specific examples. For instance, I can't find the first 4 anywhere....