98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Hlookup
Hlookup
Resolved · Low Priority · Version Standard
Finlay has attended:
Excel Advanced course
Hlookup
I am doing a hlookup on a range (possibly over 100 rows). My formula is working but my problem is that it takes too much time to go and manually edit the formula to change the row index number and increase it by one. For example the row index number has to change in order to pull in the right data....eg 5,6,7,8 etc up to over 100. Is there a quick way to do this or do I have to manually enter the row index numbers in over 100 rows?
RE: hlookup
Hello Finlay,
I hope you enjoyed your Excel training session with us.
In response to your question, I cannot think of an easy way of doing this, without getting into VBA. However, something that might at least make this problem a bit easier, would be to create a row that only has the index numbers going across. Then in your lookup formula, reference the first cell of that row, instead of an actual number. Then you can drag the formula across, and it will pull those row index numbers across as well. This assumes that the row index numbers you have listed are in exactly the right order for the data you are trying to get.
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:DATEDIF functionThe DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002. |