....but you could use a formula in columns E and F and then copy > paste special > values over columns C and D, i.e. in E1
=VLOOKUP(C1,$A$1:$B$100,2,
copy across to F1 and then down both columns
regards, barry
Title | # Comments | Views | Activity |
---|---|---|---|
excel file | 5 | 44 | |
How to check and batch replace text within a formula in an Excel spreadsheet possibly hundreds of files | 6 | 41 | |
Macro to Send Appointment from Excel | 1 | 29 | |
Excel 2010 - Text not aligning at bottom of cell! | 5 | 16 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!