Quote:
Originally Posted by Wetordry
Simple solution: Vlookup
Cells:
a1) 1/22/2007
b1) 6.633
c1) Jan 22, 2007
d1) 51.11
Step1)In a new column (column e) lookup using the following formula:
=VLOOKUP(A1,C: D,2,false)
run this formula for all your 1200 rows
Step 2) Select all cells and sort by column e
/Done. takes 30 seconds
|
Given =VLOOKUP( lookup_value, table_array, col_index_num, [range_lookup]), I think you have the lookup_value and table_array flipped.
It should be =VLOOKUP(C1, A:B,2,"false").
The way you have it, you won't find the two bolded dates (from column A) in column C.
__________________
Do Not Put Aftershave on Your Balls. -604CEFIRO
Looks like I'm gonna have some hot sex again tonight...OOPS i got the 6 pack. that wont last me the night, I better go back and get the 24 pack! -Turbo E
kinda off topic but obama is a dilf - miss_crayon
Honest to fucking Christ the easiest way to get a married woman in the mood is clean the house and do the laundry.....I've been with the same girl almost 17 years, ask me how I know. - quasi
|