|
Re: Returning a cell value
Use Index...
e.g.
=Index(A1:A100,Match(X1,B1:B100),0)
will return from column A, the corresponding value to the match of X1 in range B1:B100
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|