The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Excel

Back to all questions

Excel

Super Learner 10 months ago
Vote Up Vote Down
0
Votes
1
Answer

I have a doubt which occurred while I was working on the H-lookup exercise. Why did the answer had the column value(2) instead of the row value (14)? Since we are working on Hlookup then shouldn’t we use the data from the rows and the corresponding row number?

#
1 Answer

365 Team 10 months ago
Vote Up Vote Down
0
Votes

Hi!
Thanks for your question.
Please bear in mind that we do not use the actual row number, but the distance from the criteria (yes, in terms of rows). So, in this case the criteria is two rows from where we are and hence we have 2.
Best,
Ned

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #.

JanuaryPromo
×
Complete Data Science Education
Get 50% OFF