Help with Vlookup to report 2nd 3rd 4th etc Matches

[Marsman]

I have been reading post after post and cannot quite figure this out.

I need to be able to do a Vlookup without changing any data as "Helper Columns" etc.

As with the following example "Sheet 1" is where is am trying to have the info populate and "sheet 2" is the Data set.

Obviously when I do "Vlookup" it is finding the information for the 1st record and pasting it into the follwoing record.

The only common column would ever be Column A. the Data in Columns B and C would change consistantly.


Sheet 1

		A B C 1 P20 LPI Value needed 2 P20 PF Value needed 3 P20 SCA Value needed 4 p19 LPI Value needed​ 5 P20 FC Value needed​ 6 P16 SCA Value needed​ 7 P19 DS FEC Value needed​ <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

Sheet 2

	A	B	C
1	P20	LPI	DS RX
2	P20	PF	US
3	P20	SCA	US TX
4	p19	LPI	DS RX
5	P20	FC	NR
6	P16	SCA	US RX
7	P19	DS FEC	DS

<tbody>
</tbody>

 

[Aladin Akyurek]

What would be the value of your first "Value needed" and that of the second?

 

[Marsman]

The value Needed is what ever is in the "C" Column for the reference from "A".

A B C 1 P20 LPI 'Sheet 2' "First Record for "P20" 2 P20 PF 'Sheet 2' "Second Record for "P20" 3 P20 SCA 'Sheet 2' "Third Record for "P20" 4 p19 LPI FILLER EXAMPLE 5 P20 FC 'Sheet 2' "Fourth Record for "P20" 6 P16 SCA FILLER EXAMPLE 7 P19 DS FEC FILLER EXAMPLE <tbody> </tbody>

<tbody>
</tbody>

 

[Aladin Akyurek]

The value Needed is what ever is in the "C" Column for the reference from "A".

A B C 1 P20 LPI 'Sheet 2' "First Record for "P20" 2 P20 PF 'Sheet 2' "Second Record for "P20" 3 P20 SCA 'Sheet 2' "Third Record for "P20" 4 p19 LPI FILLER EXAMPLE 5 P20 FC 'Sheet 2' "Fourth Record for "P20" 6 P16 SCA FILLER EXAMPLE 7 P19 DS FEC FILLER EXAMPLE <tbody> </tbody>

<tbody>
</tbody>

I don't understand your reply. What is: 'Sheet 2' "First Record for "P20"?

 

[Marsman]

I don't understand your reply. What is: 'Sheet 2' "First Record for "P20"?

"Sheet 1" is where I am placing the Vlookup formula in Cell "C1" referencing cell "A1" (P20)

"Sheet 2" is the data I am getting the table Reference from, which have multiple records of the P20 in "Sheet 1" Cell "A1"

I am not able to figure out how to get the formula or any formula to be able to input into column C of "Sheet 1" to be able to report the different data, BEYOND the First Record, from "sheet 2"

for this example.... =vlookup(a1,'sheet 2'!$a$1:$c$7,3,false)


Sheet 1

		A B C 1 P20 LPI =vlookup(a1,'sheet 2'!$a$1:$c$7,3,false) 2 P20 PF =vlookup(a2,'sheet 2'!$a$1:$c$7,3,false) 3 P20 SCA =vlookup(a3,'sheet 2'!$a$1:$c$7,3,false) 4 p19 LPI =vlookup(a4,'sheet 2'!$a$1:$c$7,3,false) 5 P20 FC =vlookup(a5,'sheet 2'!$a$1:$c$7,3,false) 6 P16 SCA =vlookup(a6,'sheet 2'!$a$1:$c$7,3,false) 7 P19 DS FEC =vlookup(a7,'sheet 2'!$a$1:$c$7,3,false) <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[gorem]

Can column B serve as another lookup criteria from sheet2 or do the data not work that way? If so, you could just use a 2-criteria vlookup array.

 

[Aladin Akyurek]

"Sheet 1" is where I am placing the Vlookup formula in Cell "C1" referencing cell "A1" (P20)

"Sheet 2" is the data I am getting the table Reference from, which have multiple records of the P20 in "Sheet 1" Cell "A1"

I am not able to figure out how to get the formula or any formula to be able to input into column C of "Sheet 1" to be able to report the different data, BEYOND the First Record, from "sheet 2"

for this example.... =vlookup(a1,'sheet 2'!$a$1:$c$7,3,false)


Sheet 1

		A B C 1 P20 LPI =vlookup(a1,'sheet 2'!$a$1:$c$7,3,false) 2 P20 PF =vlookup(a2,'sheet 2'!$a$1:$c$7,3,false) 3 P20 SCA =vlookup(a3,'sheet 2'!$a$1:$c$7,3,false) 4 p19 LPI =vlookup(a4,'sheet 2'!$a$1:$c$7,3,false) 5 P20 FC =vlookup(a5,'sheet 2'!$a$1:$c$7,3,false) 6 P16 SCA =vlookup(a6,'sheet 2'!$a$1:$c$7,3,false) 7 P19 DS FEC =vlookup(a7,'sheet 2'!$a$1:$c$7,3,false) <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

Should they be: DS RX and US?

 

[Marsman]

Should they be: DS RX and US?

the data is kind of irrelevant that is column C on "Sheet 2", unless you are trying to elude to the Vlookup will need 2 types of criteria in order for it to work.

I "simply" need to be able to have the table show the first record then look for a 2nd record.

So the vlookup would find the First "P20" and report what is in the adjacent column of the same row, than find the Second "P20" and that info, so forth so on.

 

[Marsman]

Can column B serve as another lookup criteria from sheet2 or do the data not work that way? If so, you could just use a 2-criteria vlookup array.

No, unfortunately the data in the second sheet is not always the same in the 2nd and 3rd columns. The only consistent data that "could" be the same is in the first column.

 

[Aladin Akyurek]

the data is kind of irrelevant that is column C on "Sheet 2", unless you are trying to elude to the Vlookup will need 2 types of criteria in order for it to work.

I "simply" need to be able to have the table show the first record then look for a 2nd record.

So the vlookup would find the First "P20" and report what is in the adjacent column of the same row, than find the Second "P20" and that info, so forth so on.

And you are decided not to affirm whether they are DS RX and US for the first two occurrences of P20...