One day, you have a situation where you have the employee name, but need the employee number. In the following image, you have a name in A10 and need to find the employee number in B10.
=INDEX(data range, row number, column number)
=MATCH(Value, Single-column data range, FALSE)
=INDEX($A$2:$A$6,MATCH(A10,$B$2:$B$6,FALSE),1)
This fixes the vlookup's issue of travelling to the left.
Regards,
Praveen KVC
11 December 2009.
Monday, January 11, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment