VLookup only works for a certain number of rows
On Thursday, July 12, 2012 11:56:41 PM UTC-4, bryan-p wrote:
Why does the VLookup formula in col B on this sheet only work up to row 13 in the array it's referencing?=VLOOKUP(A4,'Q1'!$A$1:$E$14,1)
If the LookUp Table is not sorted in ascending order
If the LookUp Table is not sorted in ascending orderBut isn't my formula for that table already sorting the data in ascending?
"Sort_order (optional, defaults to TRUE) indicates that the first column in the array is sorted. If this is true, then VLOOKUP will return the closest match to the search_criterion.
I have a little different take on it ... I think the SORT function as it sorts in Asc order by pushing the blanks to the bottom of the populated rows is not truly sorting in Asc order ... I would like to call this way of sorting in Asc order as the SweetenedSort in Asc order.
Some community members might have badges that indicate their identity or level of participation in a community.
Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:
- Post an answer.
- Having your answer selected as the best answer.
- Having your post rated as helpful.
- Vote up a post.
- Correctly mark a topic or post as abuse.
Having a post marked and removed as abuse will slow a user's advance in levels.
View profile in forum?
To view this member's profile, you need to leave the current Help page.
Report abuse in forum?
This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.
Reply in forum?
This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.