How can I search a worksheet for contentmatching a specified cell's content

[LLA]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I want to search a worksheet for a value that matches the value in a specific cell then returns the contents of a cell related to the matched cell. Something like:
If B is the cell whose contents (a number) is equal to the contents of cell A, return the contents of C(B), where C(B) specifies a cell relative to B.

 

[John McGhie]

You want the VLOOKUP function.

Read its entry in the help very carefully: it's tricky.

Make sure you set range_lookup to FALSE, so you know when you did NOT find
something.

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I
want to search a worksheet for a value that matches the value in a specific
cell then returns the contents of a cell related to the matched cell.
Something like:
If B is the cell whose contents (a number) is equal to the contents of cell A,
return the contents of C(B), where C(B) specifies a cell relative to B.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]