I guess I was all over the place with my post. the way the syntax reads is hlookup(lookup_value,table_array,row_index_num,[range_lookup].. I think.. The way I set up my data sheet is each row has a employee name is associated with a row. so employee John Doe is row number 7.. I have very lengthy...
Hello Everyone.. This is my first post ever on Chandoo.org and from what Im seeing so far this looks like the place to go for excel help. Here goes my question
I have 60-70 very lengthy Hlookup formulas in a spreadsheet in doing for work. I was wondering if there is a way to change the "row...