Lookup...?

[Anto111]

Hi Guys,

I am trying to find a matching value specificed in a particular cell within
a seperate range of cells and then return the value adjacent to the matching
cell from that range.

For example, If I have the word "dog" in cell F6 and know it is contained
somewhere within the range A7:A35, I then want excel to return the value in
the cell adjacent to where "dog" is contained (ie somewhere between B7:B35).

Many thanks in advance,

Ant

 

[muddan madhu]

use this =VLOOKUP(F6,A7:B35,2,0)

 

[Anto111]

Really sorry, I thought I would understand the answer better if I used a
simplified example, but I don't - completely my fault.

What I really need is the value from the word "Dog" to be returned using
data from a seperate workbook where the columns are not directly adjacent
(i.e. more than 1 column apart).

For my specific example.... I specify the word I want in F6 in the current
workbook and need to find this word in a seperate workbook somewhere within
the range A7:A35. I then need this to return the corresponding value
contained in that workbook within the range G7:G35.

Really sorry to be a pain,

kind regards,

Ant

 

[Don Guillett]

try this idea. The other file need NOT be open
=VLOOKUP("Dog",'C:\yourfolder\[yourfile.xls]yoursheet'!$a$7:$g$35,7,0)