Hi your teaching skills are great, I learned a lot. BIG Thank you. But I still have 1 query: at 00.27.40, in full record section if I have a table like your 'source data' (A4:E10) and I need to put the VLOOKUP for entire table vertically having nothing in last, first,email and phone, can I do that so that I can get the value of all last, first,email and phone at a time for each A4, A5, A6..A10 by dragging the formula to right side and down at a time? Please help. Again THANKS A LOT. Subscribed !!