I have a list of 1-100 in column A. Column B has a list of corresponding names.
What I want is to be able to type "10" into say cell D5, and have cell E5 display the name from B10. I think I need to use the FIND function but I can't figure out how.
I have a list of 1-100 in column A. Column B has a list of corresponding names.
What I want is to be able to type "10" into say cell D5, and have cell E5 display the name from B10. I think I need to use the FIND function but I can't figure out how.
use INDIRECT
like
in E5Please Login or Register to view this content.
if in A there are other numbers than 1..100 then use VLOOKUP formula
In E5 Cell
=VLOOKUP(D5,A:B,2,FALSE)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Use Vlook up function , even use match and index.
but vlookup is simple and smart way.
Hmm I'm really close. Sixthsense you actually answered what I asked, but it's brought up a new issue.
What I'm actually doing is have a list of tabs from 1-100. I'm using a formula to output the tab name, so D4 is actually:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
I'm not sure where I got that formula, but it does successfully output the tab name and display "10". But I can't get excel to recognize that cell as an actual value, so I can use D4 in my VLOOKUP formula. Ideas?
Because MID is a TEXT function which outputs TEXT RESULT "10" instead of real number 10
Try this...
=VLOOKUP(IF(ISNUMBER(D4+0),VALUE(D4),D4),A:B,2,FALSE)
Yep that worked. I actually changed the D4 cell itself with the +0 but same difference. Thanks guys!
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks