Hello. I'm a newbie MS excel user and I need some help with a question. I'll attach the screenshots below, please help me with the Vlookup formula!
Thanks in advance,
Poojitha.
mastersheet.png
Hello. I'm a newbie MS excel user and I need some help with a question. I'll attach the screenshots below, please help me with the Vlookup formula!
Thanks in advance,
Poojitha.
mastersheet.png
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Try
in I40 (region)
=iferror(Vlookup($c40,source!$C$39:$F$74,3,0),"Retired")
"Department"
=iferror(Vlookup($c40,source!$C$39:$F$74,2,0),"Retired")
"Salary"
=iferror(Vlookup($c40,source!$C$39:$F$74,4,0),"Retired")
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks