vlookup Question?

Soldato
Joined
5 Mar 2007
Posts
2,858
Location
Macclesfield
Hello,

Can anyone help me with a vlookup query?

I have two columns of data, one is a ID the other is a date, in a third row I have just the ID, I have a vlookup formula that reports the date, next to the ID I have, the formula is:

=VLOOKUP(D2,$A$2:A2:B331, 2,FALSE)

I’d like this formula to be expanded, so it not only reports the date, but the rest of the data in that row?

As is, column ‘E’ contains the formula and obtains the ID from column ‘D’, it then checks for the same ID in column ‘A’ and reports the date from ‘B’ in column ‘E’ (I hope that makes sense!).

I’d like the formula to do the same but run in column ‘AB’, check the ID in column ‘AA’ against ‘A’ and if it finds a match report back rows ‘B’ to ‘Z’ in columns ‘AB’ – ‘AZ’?

Is that even possible?

Seems simple but I have no idea where to start!

Thanks for any help
 
Last edited:
If i Understand what you want correctly trhen you just need to copy the same forumla into all your cells AB - AZ then change the result part of the forumla.

so =Vlookup($AA1,$A$1:$Z$100,2,False)

If this formula is in column AB it will return the result in Column B for the matched ID.

If you then copy the same forumla into the next cell but change the 2 to a 3

=Vlookup($AA1,$A$1:$Z$100,3,False)

This will return column C so on and so forth. So Column AC will have a 3 in there and return column C, AD will have a 4 and return column D etc.

Easier than manually typing the number into each formula I find it easier to just have numbers in the top roq on your sheet.

So 1 to 26 in row 1 columns A to Z. Just fill the series along instead of typing in.

then Change the forumla

=Vlookup($AA1,$A$1:$Z$100,2,False)

to

=Vlookup($AA2,$A$2:$Z$100,A$1,False) and fill it along and it will look at the correct column number automatically.

Let me know if this is not clear or i have misunderstood what you were looking for.
 
Back
Top Bottom