VLOOKUP function does not work when you include more than 2 rows in the function after last row of data in a sheet.2 Recommended Answers
The following function will report correctly the data you are looking for:
complains that the match of "OP 1" cannot be found and you result ends up to be N/A
a) At the moment 21, rows 1 to 13 have something somewhere in a row filled in, rows 13 onwards has nothing entered in to any of their columns just yet
b) answer to this is the same as above really
c) the blank rows are the ones that are after row 13, none of the rows 1 to 13 are completely blank
d) data in column A is something like
Row 1 : OP 1
Row 2 : OP 2
Row 3 : OP 3
Problems with the Tips
- that's good happy and able to do that
- problem is that the spreadsheet will be filled in eventually by multiple people (shared spreadsheet). And for not not all data is filled in. As this will happen over time. I don't want to have to changing to formula's to everytime we get another row added to the speadsheet to update the stat's done on the data
- 4th parameter to the VLOOKUP is not the issue here
- using the open ended ranges is EXACTLY what I would like to do. However am getting the same errors. And in trying to workout what I'd done I went to use the set range with numbers - which is where the issue shows up.
-- other things to note here. The original spreadsheet was created from an Excell import. All the formular are working correctly in Excell its only after importing into Google Docs.
- The issues I point out here : are me trying to work out why Google Doc's has showed N/A# in almost all the blocks where I'd has formular insterted. And with those for VLOOKUP this is what is happening.
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.