This is very interesting & helpful;however, it's a bit irritating to change the Cell and column No. when coppying the formula accross the columns. Perhaps, you need to show us more tricks.
Thanks - glad you found it useful. You can make life a bit easier by making the cell reference the VLOOKUP function refers to absolute. To do this, click between the column and row references in the formula bar and press F4, then Enter. Now you'll be able to copy the function across, but you'll still have to change the column reference for each field. I'll post a short video demonstrating this on YouTube.
This is very interesting & helpful;however, it's a bit irritating to change the Cell and column No. when coppying the formula accross the columns. Perhaps, you need to show us more tricks.
thuynguyenable 2 years ago
Thanks - glad you found it useful. You can make life a bit easier by making the cell reference the VLOOKUP function refers to absolute. To do this, click between the column and row references in the formula bar and press F4, then Enter. Now you'll be able to copy the function across, but you'll still have to change the column reference for each field. I'll post a short video demonstrating this on YouTube.
NetresultTraining 2 years ago
The data validation is really cool Ialways wondered how they did that
ellis4140 3 years ago
Well done. This is a great example to show people. I appreciate the use of Named Ranges incorporated into the steps.
SirWolfgaar 3 years ago
thanks, it helped me with my ICT work.:D
IPINTNA 3 years ago
You're very welcome! This function is one I know a lot of people have difficulty with, so glad you liked it.
NetresultTraining 3 years ago