Help please
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 |
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 |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com