ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Selecting an Item from a List and getting a different item to pop. (https://www.excelbanter.com/excel-worksheet-functions/7558-selecting-item-list-getting-different-item-pop.html)

Matt

Selecting an Item from a List and getting a different item to pop.
 
I want to be able to select an Item from a List and have 1 of 2 words appear
in a near by cell. Is this possible?

Frank Kabel

Hi
maybe VLOOKUP is what you're looking for. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt" schrieb im Newsbeitrag
...
I want to be able to select an Item from a List and have 1 of 2 words

appear
in a near by cell. Is this possible?




All times are GMT +1. The time now is 08:26 PM.

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