VLookup a specific # in a cell that contains multiple #s...then paste row info

Good evening All,

Is there a way to do the following:

In the tab titled RFP 21, can I import (from the data tab) the information in columns B and C (the Doc and File) using a formula that will look up the number 21 from Column A (of the data tab).

So, for example, tab entitled RFP 21 will contain the Doc and File data from rows 2, 3, 5, etc.

Please help!

Thanks!

I'm sorry to bother...I have another issue.

The original spreadsheet contains 80,000 rows in the data tab. The other tabs, RFP 1, RFP 2, RFP 3, etc. will contain many rows also.

I tried using this formula, but am not having luck. Here's a sample for you to take a look at:
test_2.xlsx

I need to be able to populate all of the tabs RFP 1, RFP 2, RFP 3, etc. based on the info in the data tab.

Thanks in advance for your help.

Hi marshak

How about this array formula in A2 (CSE), copy across and down.

Formula:

Please Login or Register  to view this content.