Thread: vlookup() function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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

Reply With QuoteReply With Quote