Auto fill in data base on certain criteria
Hi All
I have a file (hereby call it "Client") with all the customers Code, Name & Salesman (cloumn A, B & C).
In another file (hereby call it "Info") I have a worksheet with lots of info related to the customers except the Salesman's info (due to system programming).
As this list of info changes every week, I need to know the Salesman related to the customer.
My question
Under "Info" column A, I will like to have a formula which can base on column B (Customer Code) and match with "Client" column A (Customer Code) and display the Salesman's name.
File "Client"
File "Info"
Code
Name
Salesman
Salesman
Code
Name
C1001
ABC Co
James
to display James
C1001
ABC Co
C1002
BCD Co
Karen
to display Peter
C1020
XYZ Co
C1003
CDE Co
Karen
to display James
C1021
DEF Co
.
.
.
.
C1020
XYZ Co
Peter
to display Bob
C1120
THU Co
C1021
DEF Co
James
to display James
C1206
YET Co
Any help will be greatly appreciated.
Thank you.
vcff
Keys to the Problem Auto fill in data base on certain criteria
Hi All
I have a file (hereby call it "Client") with all the customers Code, Name & Salesman (cloumn A, B & C).
In another file (hereby call it "Info") I have a worksheet with lots of info related to the customers except the Salesman's info (due to system programming).
As this list of info changes every week, I need to know the Salesman related to the customer.
My question
Under "Info" column A, I will like to have a formula which can base on column B (Customer Code) and match with "Client" column A (Customer Code) and display the Salesman's name.
File "Client"
File "Info"
Code
Name
Salesman
Salesman
Code
Name
C1001
ABC Co
James
to display James
C1001
ABC Co
C1002
BCD Co
Karen
to display Peter
C1020
XYZ Co
C1003
CDE Co
Karen
to display James
C1021
DEF Co
.
.
.
.
C1020
XYZ Co
Peter
to display Bob
C1120
THU Co
C1021
DEF Co
James
to display James
C1206
YET Co
Any help will be greatly appreciated.
Thank you.
vcff
In cell A2 of "Info", try this formula:
=VLOOKUP(B2,Client!A:C,3,FALSE)
Copy the formula down column A as far as you have codes in column B.
Hope this helps / Lars-Åke
- Download the Microsoft Windows ISO (installation device) from the following website:
- http://www.microsoft.com/en-us/software-download/windows10
- Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
- Extract the ISO file to a separate USB device or burn the program to a compact disc.
- Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.
Another Safe way to Fix the Problem: Auto fill in data base on certain criteria:
How to Fix Auto fill in data base on certain criteria with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems which need to be fixed.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Fast Solution to Problem: autosum only gives positive numbers, i want to subtract and see negative numbers too,Tech Support: Backup Failed Error Codes 0x80070005 AND 0x8078008A.,[Solved] backup and restore problem,Troubleshoot:Backup to network but not given the option?? Error,How Can You Fix - AVCHD MTS Files Crash Windows Live Movie Maker?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?
No comments:
Post a Comment