.. match the value in cell A1 with a list of cells in different location.
You need to link all of those different location cells into a single
contiguous col or row range somewhere, then you can apply MATCH in the normal
way to match the lookup value against that contiguous range, eg:
=match(A1,ContiguousRange,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Eric" wrote:
Does anyone have any suggestions on how to use the function match?
For example, I would like to match the value in cell A1 with a list of cells
in different location.
=match(A1,[C2,F56,H8,J11],0), but the syntax is wrong.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric