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?
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