Remembering lookups

A

Aitchy

I know I should remember how to do this but I don't :)

Given a table of data I want a formula to look for a value within the table
and return a second value from a prescribed column on the same row.

As a Second formula to also return a value from a prescribed row in the same
column as the search value.

Thanks Aitchy
 
A

Aitchy

The answer would be like the "Index" function but in reverse. Find a value in
a range and return the row number and column number of the range.
 
N

Nayab

Probably u need to use the vlookup/hlookup/lookup function and then
find the index and then do an indirect on it. It will b better if u
can give a more detailed explanation of ur requirement
 
Top