Hi is it possible to use vlookup to extract data on the row below a reference?
A B C D
1 Donna xxx xxx xxx
2 xxx
3 Vicky xxx xxx xxx
4 xxx
So if I do a vlookup formula for Vicky and want to display the results from d4 is that possible?
Thanks
Ian
A B C D
1 Donna xxx xxx xxx
2 xxx
3 Vicky xxx xxx xxx
4 xxx
So if I do a vlookup formula for Vicky and want to display the results from d4 is that possible?
Thanks
Ian
Last edited: