2 criteria for a vlookup ?
I need to look up a sales order number and a part number to populate another field - so this looks at sales order but I also need it to look at part number? Can these be combined somehow? Thank you!
=VLOOKUP(C2,lookup!B16:F365,5,FALSE)
=VLOOKUP(F2,lookup!B16:F365,5,FALSE)
Anwsers to the Problem 2 criteria for a vlookup ?
Download Error Fixer for Free Now
Hi,
I assume you want to populate column H
=index($H$16:$H$365,match(C2,$F$16:$F$365,0),match(F2,$G$16:$G$365,0))
- 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.
Recommended Method to Fix the Problem: 2 criteria for a vlookup ?:
How to Fix 2 criteria for a vlookup ? with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will scan your computer. The errors will be shown in the scan result.
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 removed.
Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: Troubleshooter of Error: 2010 office word print only one page,Troubleshoot:1x10001c30 address error \"unable to be written\" error message on shutdown started after downloading Explorer 8 and then deleting Explorer 8.,2007 Word and spell check problem [Anwsered],How Can I Fix - 150 HOUR TO BACKUP 200GB TO EXTERNAL HARD DRIVE?,How to Fix - 2007 Excel split panes?,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32
No comments:
Post a Comment