Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lookup/vlookup/hlookup
|
|
|
The UK's most regular 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. |
Lookup/vlookup/hlookup
Resolved · Low Priority · Version Standard
Reply Fri 7 Mar 2008, 15:41Delegate Scott said...
Scott has attended:
Excel Advanced course
Access Introduction course
Lookup/vlookup/hlookup
How can I look up 2 criteria and return an answer - e.g find criteria in column A, find second criteria in column b and then return the answer from column c?
For upcoming training course dates see: Pricing & availability
RE: lookup/vlookup/hlookup
Hello Scott,
I hope you enjoyed your Excel training session with us.
In response to your question, you cannot actually do a lookup based on two separate columns, and then returning the results from the third column. However, what I would suggest is that you concatenate columns A & B in your lookup and your results tables. Then you can perform your lookup based on the concatenation. To concatenate, use the following formula:
=CONCATENATE (text1,text2,...)
So for your example, this may look something like:
=CONCATENATE (A1," ",B1)
I added a <space> between A1 and B1, so that the concatenation doesn't merge the two words together. You can add any text or characters you would like by using quotation marks.
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
|