Reasons why VLOOKUP is not working

-


1. VLOOKUP Cannot Look to its Left

What this means is if the data you are matching for is not in the left side column, 
i.e. you want to match a data which is in 2nd column and 1st column value is required to be displayed then It will not be working.

 Solution:
1. Keep the matching column in first or left most column of the table/selection area.
2. The solution to this involves not using VLOOKUP at all. Using a combination of the INDEX and MATCH functions of Excel is a common alternative to VLOOKUP. It is far more versatile.

2. Your Table Contains Duplicates

Ok, so your list should have duplicates. In this case a VLOOKUP is not what you need. A PivotTable would be perfect to select a value and list the results instead.

3. The Table has got Bigger

update your table reference


Source: https://www.ablebits.com/office-addins-blog/2014/04/09/why-excel-vlookup-not-working/

Comments

Post a Comment

Popular posts from this blog

Command Line tool for Android and iOS [ adb and cfgutil ]

-
Well if you tech geek, you would be loving command line tools I just love them. and the top most reason is performance, its really fast , no gui, simply a command and done, no loading nothing for Android  adb | android debug bridge if you are a mobile tester or developer you must have followed certain steps to load you apk to your devices download the apk file in your system and move to your device memory after connecting with USB. then find that apk file and then install it and that too after approving the file manager app to do so. also for uninstalling, search the file, long select drop to uninstall and uninstall it. Well in command line you just need adb in your system. Step 1(one time): Download adb in your mac/windows/unix Step 2(one time): if you are on windows platform, set the path of the adb inside your environment variables [refer here to know how to setup] Step 3(one time): enable USB debugging in mobile device [follow link to do so] Once this...
Read more

Convert Chrome recording to Vugen Script

-
Image
Hello All, Today we will learn how we can convert a chrome recording to VuGen script. Simply turn on the F12 [developer tools] in chrome and go to network Click Record [Auto turned on] Record your steps Now Right click on any of the request in dev tools and say save a HAR. the content will be saved in JSON format as HAR file open the HAR file in vugen Script ready. ----------------------------------------------------------------------------------------------------------------- Even you can read the data in easy format  by following below steps: Use any tool to convert JSON format to XML format. and you can now easily read all the request and their response.
Read more

Jmeter-CheatSheet

-
Image
  Functions and Variables  Jmeter Time - ${__time(dd/MM/yyyy hh:mm:ss)} UUID - ${__UUID()}  Email (Random) - ${__V(${__UUID()}${__Random(1,90000000,)}@gmail.com)} Random - ${__Random(0,10)}  Random Date - ${__RandomDate(,,2050-07-08,,)}  Random String - ${__RandomString(10,abcdefg)}  Time shift - ${__timeShift(dd/MM/yyyy,21/01/2018,P2D,,)}  Convert epoch - ${__dateTimeConvert(1526574881000,,dd/MM/yyyy HH:mm,)}  Upper Case - ${__changeCase(Avaro omnia desunt\, inopi pauca\, sapienti nihil,UPPER,)} Lower Case - ${__changeCase(LABOR OMNIA VINCIT IMPROBUS,LOWER,)}  URL encode - ${__urlencode(Word "school" is "école" in french)}  URL decode - ${__urldecode(Word+%22school%22+is+%22%C3%A9cole%22+in+french)}  Thread Num - ${__threadNum}  Thread Group - ${__threadGroupName}  Escape HTML - ${__escapeHtml("bread" & "butter")}  Unescape HTML - ${__unescapeHtml(<Français>)}  CRLF - ${__unescape(\r\n)} Split - ${__sp...
Read more