- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.
First make sure there is an "=" sign at the beginning of the formula. If there is and the formula still shows in the cell go to Preferences and click View. Make sure the "Formulas" box under Window Options is not checked.
The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets A2 is the cell I want to look up Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $ 2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns 0 is the value to complete the formula