[VIEWED 10310
TIMES]
|
SAVE! for ease of future access.
|
|
|
avii
Please log in to subscribe to avii's postings.
Posted on 01-06-20 4:06
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
I have below set of data in excel and would like to create formula in next tab, so whenever I type dealer #, agent name should populate automatically in another tab. Dealer # Agent 720486 AART 720548 BCCD 720962 SISI 719728 PRUF 720541 PARA 719730 PROF 720280 TOSS 721007 TFIT 720516 DOTD 720526 DHTD Please help, thanks in advance.
|
|
|
|
GwachAquarian
Please log in to subscribe to GwachAquarian's postings.
Posted on 01-06-20 6:19
PM [Snapshot: 92]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
ujl
Please log in to subscribe to ujl's postings.
Posted on 01-06-20 6:52
PM [Snapshot: 108]
Reply
[Subscribe]
|
Login in to Rate this Post:
1
?
Liked by
|
|
This will require bunch of nested formulas. There are various methods you can use. What you can do is use data validation technique. You can then use either vlookup function or index and match function. But using this along won't auto-populate the dealer name. What you need to do is use nested formula using IFNUMBER and SEARCH as well.
|
|
|
learningpath
Please log in to subscribe to learningpath's postings.
Posted on 01-06-20 6:58
PM [Snapshot: 111]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Avii, you can use below formula to get the result you are looking for. IFERROR(VLOOKUP(C3,A:B,2,FALSE),"") Basically copy and paste the formula in column D. It will show blank if there is no value in but as soon as you enter the value, it will show you the agent name. Let me know if this help or if you need further help. IFERROR(VLOOKUP(C3,A:B,2,FALSE),"") A B C D Dealer# Agent Dealer# Result 720486 AART 720491 BCCD 720491 BCCD 720496 SISI 720501 PRUF 720506 PARA 720511 PROF 720516 TOSS 720516 TOSS 720521 TFIT 720526 DOTD 720531 DHTD
|
|
|
learningpath
Please log in to subscribe to learningpath's postings.
Posted on 01-06-20 8:30
PM [Snapshot: 168]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Hi Avii,
In my earlier post, I was trying to put the table in below format so it make sense. You can use this formula in any tab where you want to see the name and change the reference cell in formula, it will populate the Agent Name you are looking for. Hope this helps.
Formula in D3 =IFERROR(VLOOKUP(C3,A:B,2,FALSE),"")
|
|
|
logan
Please log in to subscribe to logan's postings.
Posted on 01-06-20 8:55
PM [Snapshot: 203]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
There are lot to watch but I liked this guy. Practice helps . https://youtu.be/kNaxTNSAtLk
|
|
|
avii
Please log in to subscribe to avii's postings.
Posted on 01-07-20 10:50
AM [Snapshot: 307]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Thank you everyone for the suggestion, I am able to do so with simple VLOOKUP. For some reason there was an error on my lookup so couldn't get what I was looking for but now it is fixed. Thanks again for your time and effort.
|
|
|
logan
Please log in to subscribe to logan's postings.
Posted on 01-07-20 6:06
PM [Snapshot: 389]
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Someone gave me a solution book of trigonometry during my high school. I failed in 1st assessment. I gave it to my teacher then I got better and pass the final.
|
|
|