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
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: