How can i copy v-lookup formula from one cell to another cells in the same column?

sheet 1


customer name customer address


hiren london


rahul





sheet 2


customer name customer id customer address


hiren uk1 london


rahul i10 india





now, in sheet1; using v-lookup i got an address of hiren from sheet2


now, i want to copy that for rahul. i want it to fatch address automatically, i don't want to enter the formula manualy.|||The first time you enter the formula you will have to enter it manually. The formula (on two lines because of Yahoo's windows, type as one line) is





VLOOKUP(lookup_value,table_


array,col_index_num,range_lookup)





The formulas to your table_array (the lookup table) need to have $ signs in the formula, which will make it an absolute reference instead of a relative reference.





Absolute reference:





$J$3, $L$10





relative reference:





J3,L10





With a relative reference when you copy the formula the references change. if you move the formula down one cell and left two cells then J3,L10 becomes H4,J11, so your lookup table won't work anymore.





With an absolute reference it doesn't matter where you copy/move the formula $J$3, $L$10 stays the same, so it always refers to the lookup table.