Hi everybody,

I just started learning about Vlookup, it's really cool stuff!
Here is my issue, i'm trying to take a selected row of about 7 cells (which are obviously all positioned horizontally) and have it inserted, via vlookup using the drop down option of 'Data Validation', to another location but having all the cells lined up vertically, meaning going down 7 cells. I would guess that a shorter explanation of what i'm trying to do is to have the vlookup transpose 7 cells.
Any help is most appreciated

Thanks!