Substitute a value in a pull down list from a lookup table

Hi,

I have a cell with a pull down list of values (slot_size), this works great because it is a simplified version of the value for the person inputting the data. However, once a value is selected, I need to replace the value with the absolute number IN THE SAME CELL. I have found several functions that can do this in a different cell and I can get that to work I can even put a function "on top" of the data validation and that works; but what I really want is when someone selects the value from the pull down menu the equivalent number is displayed.

Is that possible?

i.e.

slot_size
32KB 32768

thx

use match and index

if A1 is your pull down list

then in B1

Please Login or Register  to view this content.

will give you the position of the data in a database sheet2

Please Login or Register  to view this content.

will give you the data 2 cells to the right of the data.

Thanks Mehmetcik,

Yes, this returns the value I want in a different cell, but I would like this value to show up after I select the pull down in the SAME cell. For instance, I am trying to use this function in the data validation formula - but it is not working.

I would like the user to pull down the slot size values: 16KB, 32KB, etc. but I want the cell to display the value in Bytes (16,384, 32768, etc.)