I have Cell B1 = 6 on a worksheet named DOC. On Cell B3 of worksheet Week 1 it has "Celina". Is there a way that if Cell B1 in DOC has number 6, Cell B3 on Week 1 will automatically become Celina.
All worksheets are in the same workbook
Likewise if Cell B1 ever has any of the following numbers, cell B3 in Week 1 will display the corresponding alaphnumerics.
1 = Troy
2 = Piqua
3 = Urbana
4 = Grnvl
6 = Celina
Thank You
Sure. If you already have a small table set up as you have shown in your post, then where ever you want the answer to be, use =vlookup(B1,$J$1:$K$6,2,0)
If you dont hjave a table lik ethat already set up, then set it up - I used J1:K6, adjust as needed
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
You could use...
=LOOKUP(Doc!B1,{1,2,3,4,6},{"Troy","Piqua","Urbana","Grnvl","Celina"})
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks