VLOOKUP / HLOOKUP Question

[Brett24]

Hello,

I hope someone can help me. I have an Excel spreadsheet where I would
like to find out a value using the VLOOKUP or HLOOKUP. The problem I
have is that the value I am trying to find is not on the same row or
column as the Item I am looking up against. For example:

Cell B7 Contains "Peter", Cell C7 Conains "Age", Cell C8 contains "21".

Cell B10 Contains "Peter". In cell C10 I would like to do a lookup
against cell B10 "Peter" and return his age of "21", how can I do this?
I know it would be easier to have "21" on cell C7 but I am working
with a file which is downloaded from another system.

Thanks,

Brett

 

[Bob Phillips]

I presume B10 is on another sheet?

Try

=INDEX(Sheet1!C:C,MATCH(B10,Sheet1!A:A,0)+1)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Brett24]

B10 is on the same sheet.

I tried your formula and it did not work. I do not understand why you
have used C:C or A:A).

Thanks,

Brett

 

[Bob Phillips]

Because I am a prat, it should have been B:B not A:A in my example.

If it is on the same sheet, and there is very little room above B10, why do
you need a lookup at all?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)