ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I auto-fill a cell dependant on the value of another cell? (https://www.excelbanter.com/excel-worksheet-functions/78131-how-do-i-auto-fill-cell-dependant-value-another-cell.html)

Naisha1000

How do I auto-fill a cell dependant on the value of another cell?
 
I'm trying to find out how to auto-fill a cell dependant on the value of
another cell. ie when I enter a item number, the item description is
automatically entered in the appropriate cell.

Bernard Liengme

How do I auto-fill a cell dependant on the value of another cell?
 
Have a look at VLOOKUP in Help then come back for more details
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Naisha1000" wrote in message
...
I'm trying to find out how to auto-fill a cell dependant on the value of
another cell. ie when I enter a item number, the item description is
automatically entered in the appropriate cell.





All times are GMT +1. The time now is 09:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com