Hi, I am working on a document and I need to do the following, If a value in sheet 1 exists on sheet 2, then i want the date of the value in sheet 2 (same row) to appear on a column in sheet 1 named date. how can you do this?
Lookup_Value = The Value in Sheet 1
Table Array = The range in Sheet 2 (Starting with the first Column the information will appear in)
Col_Index_Num = the number of rows to the right the date appears (1 is the column you are looking up, so one right is 2)
Range_Lookup = False for Exact match