LOOKUP function for multiple rows?

**JC_VILLA789** · 01-08-2015, 04:56 PM

Test Sheet 1.xlsx Test Sheet 2.xlsx

Hello again, Excel Forum!

I have attached two files... Test Sheet 1 and Test Sheet 2.

I am trying to populate Test Sheet 1 with the info from Test Sheet 2 using the Equipment Number as the lookup value.

Normally, this isn't much of an issue, as I have often used the VLOOKUP function to search other sheets when there are unique numbers....

However, in this situation, Test Sheet 2 has my lookup value appearing 30 times on different rows.

Have any of you come across this issue before?

Any help/advice is appreciated.

**protonLeah** · 01-08-2015, 06:26 PM

Since the rows of workbook 2 correspond to the columns of workbook 1,

1. Maybe with both workbooks opened, in B2 of Sheet1:

Please Login or Register  to view this content.

copied across to column AF, then down.

2. When you close workbook #2 the formula will change to include the folder info:

=INDEX('C:\Downloads.New\[Test Sheet 2.xlsx]Sheet1'!$A:$D,MATCH($A2,'C:\Downloads.New\[Test Sheet 2.xlsx]Sheet1'!$A:$A,0)+COLUMN(B$1)-2,4)

You might use IFERROR to get rid of NA'a when there are no ID nums in column A

**JC_VILLA789** · 01-09-2015, 09:48 AM

Thank you very much... Still not sure exactly WHY it's working, but it's working!

LOOKUP function for multiple rows?

LinkBack

Thread Tools

Rate This Thread

Display

LOOKUP function for multiple rows?

Re: LOOKUP function for multiple rows?

Re: LOOKUP function for multiple rows?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Multiple Lookup Values rows and columns to lookup a single target column on the right end.

[SOLVED] Is it possible to lookup multiple values and return multiple rows of results?

When using match function can your lookup array be multiple rows and columns

Lookup in multiple rows

Lookup with multiple rows.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions