Help please
Sounds like VLOOKUP. Check the examples in Help.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Josie" wrote in message
...
Hi
I need to enter a reference number in one cell & then this to bring up
info
in corresponding cells.
Example:
If I enter 1234 in any cell in column A I want "a name" to appear in
corresponding cell in column D, "a location" in corresponding cell in
column
J & "a deptartment" in corresponding cell in column L.
Thanks
|