LinkBack URL
About LinkBacks
Can someone help decode this formula?
=VLOOKUP($E23, 'Machine Hrs'!$F$11:$N$35,9,FALSE)
Mostly need to know what the last 2 items mean - 9,FALSE
Thanks, Tern
Can someone help decode this formula?
=VLOOKUP($E23, 'Machine Hrs'!$F$11:$N$35,9,FALSE)
Mostly need to know what the last 2 items mean - 9,FALSE
Thanks, Tern
It would be valuable for you to read the Help page for VLOOKUP.
VLOOKUP looks for a value in the first column of a rectangular range. $E23 is the value you are looking for.
'Machine Hrs'!$F$11:$N$35 is the range you are searching.
9 is the column within that range that VLOOKUP will return the result for. For this example, if the value in $E23 is found in F12, then VLOOKUP will return the value in N12.
FALSE means that VLOOKUP will look only for an exact match of $E23. If no exact match is found, it will return an error. If instead you use TRUE, then VLOOKUP will expect the values in the first column to be sorted. If it does not find an exact match, it will quit when it sees that your value was not found where it expected it to be, and will return the highest value that is not greater than the one you are looking for.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thank-You!
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationicon.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks