Hi
the floowing line is coming from the excel help
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)
How can i use this function in macro where the lookup_value is in A1 format,
the table_array is a variable (rng) ?
the lookup funtion is rffered to another sheet in the same workbook e.g.
sheet1 is where the function works but the reference array is in sheet2.