Excel experts see within

[neorichieb1971]

At work we have a spreadsheet where you put a value in column A and column B automatically puts a corresponding value in that cell.

IE

if you put 100 in column A it puts "fred" in column B next to it.
if you put 101 in column A it puts "Richard" in column B next to it.

I don't know the terminology for that feature so its hopeless using google to find out how to do it. Do you know the terminology for that feature or how code it? In the spreadsheet I use there is no equation in the cells.

thanks for any advice.

[caldwert]

Sounds like there is a vlookup being run off of another file. So you'd have =vlookup("column A", range of the names list its linked to, then the range column on the names worksheet that you'd want to output, then false so if it isn't an exact match then nothing gets output). So =vlookup(A1, Namelist.xlsx$A$1:$B$2, 2,false) So provided cell A1 is Fred's number and his name is Fred in cell B1, then its looking for that number in A1 in the Nameslist file, and outputting "2" meaning the 2nd column of whatever range of columns and cells you have. So if you start in the middle of the sheet, say $C$1:$D$2, then D is still the "2" or 2nd column. As far as the false, if you it isn't an exact match of the A1 in the file you're working in originally, then it won't output anything.

Sorry if this isn't what you were looking for or already know all of this. The only part confusing me is you say there's no equation in the spreadsheet you're using.

[TransatlanticFoe]

Visual Basic code in the spreadsheet perhaps? Alt+F11 takes you there, though if you don't know it exists you probably won't know what to do when you're in there.