[Show all top banners]

avii
Replies to this thread:

More by avii
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 Excel formula help
Keywords associated with this thread

EXCEL FORMULA
[VIEWED 3073 TIMES]
SAVE! for ease of future access.
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.
 
Posted on 01-06-20 6:19 PM     [Snapshot: 92]     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 
 
Posted on 01-06-20 6:52 PM     [Snapshot: 108]     Reply [Subscribe]
Login in to Rate this Post:     0       ?        
 

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.
 
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

 
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),"")

 
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
 
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.

 
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.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 365 days
Recommended Popular Threads Controvertial Threads
TRUMP 2016!!! Here is why?
महानियिका प्रियंका कार्कीजीलाइ खुल्ला पत्र !
How long does it take to get I485 approved?
What stocks to buy -- Any recommendation
कोमल ओलि र धिरेन्द्र बिचको अफेयर
मलाई ब्रेड खायो कि सारै पाद आउछ..
Anyone renewed their passport through DC embassy lately?
which stock to buy
Wedding Costs in Nepal ? Party, Band Baaja !!!!???
Returning to Nepal
TPS FEDERAL NOTICE
I m offered a Job in Bank in Nepal, should i go back ?
Buying land in kathmandu
Hpw to bring huge sum of money from Nepal to US
प्रियंका कार्की फोटो अबलम भाग २ , ३ जून २०१६ copyright @पुन्टर
Udus killer spray
##केटा हो ,*Monthly* कती *SAVE* हुन्छ ? ##
ओपन challenge फर गनाउने (underwear)
TPS to GC (PERM-I140-I485) TimeLine
लिङ्ग को आकर कत्रो?
Funny jokes
Presidential rights to assassination rights?
भात भन्या भात हो!
महानियिका प्रियंका कार्कीजीलाइ खुल्ला पत्र !
TRUMP 2016!!! Here is why?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters