Hello need a formula to read col a and b in table 1, and then search table 2 and bring back "status" data. Would usually use a vlookup, but as I have two values I am unsure how to proceed?
Table 1Table 2
COL A COL B Order Task code status
95979366 LSP 95956074 LCP TEPL
95979366 IPL 95939920 LSP TSCO
95979367 LCP 95939920 LCP TRWR
95979367 LSP 95939910 LSP TSCO
95979369 LCP 95939910 LCP TSCO
Last edited by Shoulin; 02-09-2024 at 02:00 PM.
Hello Shoulin,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks