i have a data table named CADATA with following columns- [CADATA]
I AM USING VLOOKUP TO POPULATE THE DATA FROM THIS TABLE IN FOLLOWING FORMAT[FORMAT]
THE VLOOKUP FORMULA IS WORKING FINE FOR FIRST CARD OR FORMAT BUT AS YOU CAN SEE MY FORMAT IS MADE UP OF 7 ROWS SO WHEN I SELECT AND DRAG DOWN THE FORMAT IT SKIPS THE 7 ROWS FROM THE DATA TABLE AND GIVE RESULT FROM 8 ROW