I will get right to it. I have an excel file with 2 sheets. Sheet 1 has a column that contains formulas (ie (18299*11151)/20067 ) Those numbers are IDs referencing questions stored in Sheet 2. What I would like to do is find a way to look up those questions and place them into the formula instead of the ID numbers.
Can someone please help
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is a sample file Forum.xlsx
The numbers in the formula on Sheet 1 refer to the qlibid column on sheet 2. What I need to do is be able to lookup those qlibid ids and create a text formula instead of and ID based formula. I hope this clears it up a bit
A way to start.
first text to column.
after that a vlookup
See the attached file.
I appreciate you taking the time to respond. However, the text to column does not work since the spacing in the formulas are not all the same
Maybe another forummember will provide another solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks