Vlookup help... I think?!?!?!

[joegio25]

Hey ladies and gentleman,

I am not positive, but I think I need to use a VLookup. Here is what I am trying to do...

I have a chart that looks as follows:

A B C D
11 X X X
11 X X U
11 U J L
12 X J P

I was trying to use VLookup to reference this chart, and look for the value '11' and return all related fields and columns. The problem I'm having is, VLookup wants to stop once it finds the first row with containing '11' It will not return all 3 rows. I need to duplicate this chart on the next page, but it is just finding the first row with '11' in it and duplicating that row however many times. Does this make sense?

 

[jberwald]

Welcome to the board.

If I understand what you need a VLookup will not work if you require different information to be returned for the same initial lookup number.

Now you say, "I need to duplicate this chart on the next page" Why not just cut and paste it?

 

[Steve=True]

H jberwald and welcome to the forum.

I would typically use an Index/Match function combination.

Do you have any experience using this?

If not, please be more specific on exactly what you are searching for and what you want returned and i am sure someone will be able to help.

Steve=True
www.exceldashboardtemplates.com

 

[crusader]

Now you say, "I need to duplicate this chart on the next page" Why not just cut and paste it?

Or set the value of destination cells equal to source cells...