HI
I would like to know how to look up data in colum A and then return the value 2 rows down and 2 colums accross.
If I find a match in a2 I want the value returned which is in c4.
Please help
HI
I would like to know how to look up data in colum A and then return the value 2 rows down and 2 colums accross.
If I find a match in a2 I want the value returned which is in c4.
Please help
=offset(A2,2,2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
How do I specify the value to search for?
Hi,
Lots of way to do this, but I would opt for
=INDEX($B$1:$C$200,MATCH("Search term",$A$1:$A$200,0)+2,2)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks