Need help setting up a lookup formula in Excel Here's what I have tried so far: I've been trying to set up the formula with my limited knowledge...

Hello and welcome to ExpertHelp.com! My name is Chad and I will do my best to help you.

Before we get started, I want to remind you ExpertHelp.com is an independent professional support company. We do not have any affiliation with Microsoft nor are we paid to provide support on their behalf. However, we have helped hundreds of customers with similar questions and believe we can help you too. OK, let’s get started! :)

What lookup formula are you looking for there are many! Look below for examples.

VLOOKUP – Vlookup is the oldest and most often used lookup formula in Excel. The first time you write a Vlookup formula is a milestone in your Excel learning. However, after using this formula for a significant amount of time, you will definitely begin to see its flaws.

HLOOKUP – The Horizontal Lookup is essentially a Vlookup transposed; instead of trying to find your lookup values vertically in columns, you are now looking horizontally through rows. The syntaxes of Vlookup and Hlookup are essentially the same; the difference is that with Hlookup you must reference horizontal ranges.

INDEX MATCH – Index Match is the best way to perform a simple vertical lookup. (The second half of this article will explain why) Because the lookup method is actually a combination of two different formulas, the syntax for writing an Index Match can initially be difficult to remember. However, after frequent use, it’s really not a difficult formula to memorize; I currently use Index Match almost exclusively for all of my lookups.

VLOOKUP MATCH – By combining the Vlookup and Match functions of Excel, the originally static column reference within the Vlookup formula becomes dynamic; now whenever you insert a column into your data set, your column reference will update so that you still have the same return value.

VLOOKUP HLOOKUP – When you combine Excel’s basic vertical and horizontal lookup formulas, you end up with a matrix lookup. A matrix lookup implies that you are looking up both a vertical and horizontal value to pinpoint the return value you want to pull.

OFFSET MATCH MATCH – The offset function in Excel is a very versatile formula that, when combined with the Match formula, can replicate the functionality of a lookup. The key difference in using the offset function is that you must start your formula with a single cell reference, typically the top left hand corner of your data range. The Match formula then allows you to move vertically and horizontally from that reference point to find your return value.

I’ll be giving you a call soon. If I don’t catch you this time, please reply with a few times that work best for you and we can connect one of those times.

Hello and welcome to ExpertHelp.com! My name is Mario and I will do my best to help you.

So that I could help you with your question, would you please let me know what needs to be done with the spreadsheet you sent us? I noticed the Stake Contact Info contains 3 blank cells (AE, AF and AG). I guess you need a formula in one of these cells. What does the formula need to do?

I will be waiting for your response,
Mario

Bob,

I am transferring this ticket over to a Excel expert (Mario). And he will be able to further assist you! Have a great day, and it was nice speaking with you!

Thanks,

Chad

Hi,

I believe I can help you with this question. I can either walk you through the steps or we offer remote support option at no additional charge. I believe I can help you much more quickly with our remote support option. If you want to move forward with remote support, I will need a temporary login in order to solve the issue via remote support. You can delete this login after we are through. To proceed with the remote support option, please download and open TeamViewer for Windows and let me know your ID and password.

Thank you,
Mario

Summary (chat & email):

• customer explains the issue
• inform the customer will be contacted by phone if requested
• solution provided by email (excel file containing the solution has been sent)
• customer's reply: "Perfect, Mario. This is exactly what I need. Thanks so much for your efficient help."
• issue solved