=VLOOKUP(A10,$A$1:$B$6,2,FALSE) entered in C1

Assumes you typed 2 in A10..............will return hat to C1


Gord Dibben MS Excel MVP


On Fri, 25 Jul 2008 07:24:31 -0700 (PDT), harsh_njoy
wrote:

Hi please suggest how to use vlookup() function for the problem given
below to identify the word for given id

A B
id word
1 tennis
2 hat
3 trial
4 ride
5 complex

2

Thanks