ExcelBanter - vlookup() function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup() function (https://www.excelbanter.com/excel-worksheet-functions/196315-vlookup-function.html)

harsh_njoy

vlookup() function

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

Mike H

vlookup() function

Try

=VLOOKUP(2,A2:B6,2,FALSE)

Mike

"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

Gord Dibben

vlookup() function

=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

All times are GMT +1. The time now is 07:52 AM.