Lookup...?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anto111 - 31 May 2008 08:19 GMT

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

Reply to this Message

muddan madhu - 31 May 2008 08:30 GMT

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

On May 31, 12:19 pm, Anto111 <Anto...@discussions.microsoft.com>
wrote:

> Hi Guys,
>
[quoted text clipped - 9 lines]
>
> Ant

Reply to this Message

Anto111 - 31 May 2008 09:01 GMT

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

> use this =VLOOKUP(F6,A7:B35,2,0)
>
[quoted text clipped - 13 lines]
> >
> > Ant

Reply to this Message

Don Guillett - 31 May 2008 13:29 GMT

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Really sorry, I thought I would understand the answer better if I used a
> simplified example, but I don't - completely my fault.
[quoted text clipped - 37 lines]
>> >
>> > Ant

Reply to this Message