Excel Q&A

RE: vlookup question

Yes - create a legend - a key. Then use vlookup to grab it in.
Let us know if you have questions on vlookup- it is covered in our advanced excel for data analysis class.

0

by WST Expert 1.

added 11 years ago

RE: vlookup question

Thanks for the swift response - My problem has got to be formulaic, but I can’t figure out my mistake for the life of me. Here is what I am attempting to do: 1. I have one sheet of names. 2. I have one sheet of corresponding letters. 3. I have a table matching the ... Read More

0

by Guest 1.

added 11 years ago

RE: vlookup question

So to clarify, in Sheet 1: the block of cells NAME is hard coded the LEGEND is also hard coded and matches the order of NAME and then you assign your LETTER to it then in Sheet 2: the LETTER is the output to display based on the order of NAME try this: go to your LEGEND, Sheet 1, cells 11 t... Read More

0

by WST Expert 1.

added 11 years ago

RE: vlookup question

I understand what you did, I think. But that doesn’t help either. Maybe it will help if I give you the backdrop. This particular workbook is a temporary ledger of all of our bankers Institutional contacts. Not individual names, merely fund names. Now we have 14 bankers covering 1500 hedge fund... Read More

0

by Guest 1.

added 11 years ago

Questions/Discussions

Sort by Date ▼ / Top Rated