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