Is there a way to override an existing cell value with the value returned from the lookup?
On sheet1 I have
On Sheet2 I have
Please Login or Register to view this content.
So when I do the lookup on sheet 1 to get the "Note" corresponding value from sheet2, I want to override say 1, and display "Do", and so on. Currently when I try to do this I get a circular reference error.Please Login or Register to view this content.
if you mean, you will have a regular value in sheet1, and you want to have the results from a formula instead...the short answer is no, you cannot do this with a regular formula.
A cell can contain either an entry (value/text etc) OR a formula - it cannot contain both.
What you may consider doing (if this is in fact what you want) is to use a helper column that will test both cells and return which ever cell contents you requiire
If you have a dummy workbook to show me, I might be able to offer better help?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks