Remembering lookups

[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

 

[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.

 

[eagleyzw]

vlookup()
hlookup()

or lookup()

 

[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