Sunday, March 27, 2016

[Anwsered] 2 criteria for a vlookup ?

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)

Solutions to the Problem 2 criteria for a vlookup ?

Download SmartPCFixer 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))

  1. Access the files on your computer via MY COMPUTER
  2. Under the C: drive, access the WINDOWS folder
  3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
  4. Delete any files within this download folder.
  5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
  6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Recommended Method to Fix the Problem: 2 criteria for a vlookup ?:

How to Fix 2 criteria for a vlookup ? with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related:
Read More: 2 Questions- Uninstalling IE and windows security center [Solved],Troubleshoot:20.7.13. Home Page Quiz on How well do you know Britain? Question: Which Jubilee is the Queen celebrating in 2012? You say 50 years. Surely Diamond Jubilee is 60 years?,Fast Solution to Error: 3 consent.exe files cannnot open start menu is it mal-ware?,Fast Solution to Problem: 1/3 of page getting cut off when trying to print on 11X17 paper in Excel 2007,How to Fix Error - 403 errors with Internet Explorer?,2 minute hang at "Welcome" screen, but only on Admin account.,2 failed updates: KB970892 error code FF, KB978338 error code 800B0100,2003 excel keeps freezing and even crashes when email is active,3D Studio Max side by side configuration error,404 not found nginx message

No comments:

Post a Comment