writer
2,661
edits
Changes
Manuals/calci/VLOOKUP (view source)
Revision as of 23:31, 15 February 2014
, 23:31, 15 February 2014→Examples
=VLOOKUP(3,A2:C7,2) : Looks up for '3' in Number Column and returns value from Square column in the same row. <br />Returns '''9''' as a result.
=VLOOKUP(3,A2:C7,2) : Looks up for '3' in Number Column and returns value from Square column in the same row. <br />Returns '''9''' as a result.
=VLOOKUP(5,A2:C7,3,FALSE) : Looks up for exact match for '5' in Number Column and returns value from Cube column in the same row. <br />Returns '''125''' as a result.
=VLOOKUP(5,A2:C7,3,FALSE) : Looks up for exact match for '5' in Number Column and returns value from <br />Cube column in the same row. Returns '''125''' as a result.
=VLOOKUP(5.5,A2:C7,2,TRUE) : Looks up for the approximate match for '5.5' in Number Column, matches the nearest value '5' and returns value from Square column in same row. <br />Returns '''25''' as a result.
=VLOOKUP(5.5,A2:C7,2,TRUE) : Looks up for approximate match for '5.5' in Number Column, <br />matches the nearest value '5' and returns value from Square column in same row. Returns '''25''' as a result.
== See Also ==
== See Also ==