Robuta

https://community.smartsheet.com/discussion/99841/vlookup-in-form Vlookup In Form - Smartsheet Community I have read through some answers and can't find what I am looking for. I want to create a form that when a certain name is selected, it prepopulates the... in formvlookupsmartsheetcommunity https://community.smartsheet.com/discussion/88210/using-vlookup-to-match-or-ignore-unmatched-strings using VLOOKUP to match or ignore unmatched strings - Smartsheet Community I use this formulat to look up the unique ID (3rd colum) to match those ID's. I want to be able to ignore the default NO MATCH output for those ID not matching... usingvlookupmatchignorestrings https://community.smartsheet.com/discussion/69178/index-and-match-or-vlookup-or-both Index and Match or VLookup or both - Smartsheet Community I am trying to recreate this excel formula in smartsheet: =IF(ISNA(VLOOKUP(B2,'Participating Hotels'!$B:$B,2,FALSE)),"Not Available","Available") * "B2" is the... indexmatchvlookupsmartsheetcommunity https://community.smartsheet.com/discussion/111790/combining-if-or-and-vlookup-across-multiple-sheets Combining If/or and vlookup across multiple sheets - Smartsheet Community I have 4 sheets: NCR Summary sheet. Supplier A sheet, Supplier B sheet, and Supplier C sheet. I want to pull information from individual supplier sheets to... combiningvlookupacrossmultiplesheets https://techcommunity.microsoft.com/discussions/excelgeneral/using-if-and-vlookup-together/3641441 Using IF and VLOOKUP together | Microsoft Community Hub I have a workbook where the first sheet has dates in the heading and the data for those columns is on another sheet. I want to combine an If statement to... microsoft communityusingvlookuptogetherhub https://community.smartsheet.com/discussion/123203/if-and-vlookup-nested-formula If and vlookup nested formula - Smartsheet Community I'm looking to create a formula that if a cell matches this criteria, vlookup a different column info for multiple cell matches as a nested formual. If Product... vlookupnestedformulasmartsheetcommunity https://community.smartsheet.com/discussion/66329/vlookup-using-dates Vlookup using Dates - Smartsheet Community Hello, I'm having some issues around a simple vlookup using dates. I have include screenshots to assist. My formula looks as follows and I am getting a... vlookupusingdatessmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-problem/4240308/replies/4240335 VLOOKUP Problem | Microsoft Community Hub How do I have the have the value entered into the "logical _test" cell be exactly as shown in the data set.My data set has "21855.5" as the "pointer"... microsoft communityvlookupproblemhub https://community.smartsheet.com/discussion/93795/vlookup-issues VLookup Issues - Smartsheet Community Problem: While I am able to input the VLOOKUP formula correctly, I having an issue with it returning correct data. I am using a form to track attendance. The... vlookupissuessmartsheetcommunity https://mail.python.org/archives/list/python-dev@python.org/thread/WND4OFSRMH2FHDMOLG26LQYTU7UJNGRU/ Mailman 3 Do we have vlookup function - Python-Dev - python.org we havepython devmailmanvlookupfunction https://techcommunity.microsoft.com/discussions/excelgeneral/autopopulating-cells-from-a-dropdown-using-vlookup-function-/4030210 Autopopulating cells from a dropdown using vlookup function. | Microsoft Community Hub I have a dropdown list which I have gathered from a table. When I put in a Vlookup function to autopopulate adjacent... microsoft communitycellsdropdown https://techcommunity.microsoft.com/discussions/excelgeneral/excel-using-vlookup-not-calculating-after-3-steps-in-spreadsheet---nas-start-pop/276297 Excel using vlookup not calculating after 3 steps in spreadsheet---#NAs start "pop up" | Microsoft... It is a workbook I created years ago. Have edited it adding different functions. I check formulas back to 2005 and all continue to work. But stops working in... https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-or-match---need-unique-returns-on-multiple-finds/3730967/replies/3731070 VLOOKUP or MATCH - Need Unique Returns on Multiple Finds | Microsoft Community Hub Hello All, Need help on this one. Having issues. I'm trying to summarize a huge list of data. In this huge list of data I need to extract (summarize)... https://community.smartsheet.com/discussion/88970/pull-most-recent-invoice-data-for-an-account-using-index-match-vlookup-max-or-other Pull Most Recent Invoice Data for An Account Using INDEX/MATCH/VLOOKUP/MAX (Or Other) - Smartsheet... Greetings! Our team uses a Smartsheet to track monthly invoices for each client. Each invoice date is listed separately for each client (see attached). We are... https://community.smartsheet.com/discussion/93114/if-vlookup IF & Vlookup - Smartsheet Community Hi there, I am trying to complete a VLOOKUP with an IF Statement but its returning a blank despite data being available in the cross-reference sheet =IF([Ex... vlookupsmartsheetcommunity https://community.smartsheet.com/discussion/93420/vlookup-across-multiple-sheets VLOOKUP across Multiple Sheets - Smartsheet Community I am trying to have a cross reference that looks across 3 different sheets. I have been successful getting it to work with just two sheets, but when i add the... vlookupacrossmultiplesheetssmartsheet https://community.smartsheet.com/discussion/93541/vlookup-with-multiple-references-in-one-cell VLookup with multiple references in one cell - Smartsheet Community Hey all, I'm not even sure what I'm after is possible, but thought I'd ask anyway. We're using a sheet to track users while they are out on test rides. Each... multiple referencesin onevlookupcellsmartsheet https://community.smartsheet.com/discussion/102576/enhance-the-vlookup-function-to-take-a-date-using-it-to-lookup-the-value-in-the-cell-history Enhance the VLOOKUP function to take a date, using it to lookup the value in the cell history -... Sorry if this is a duplicate. I can see the Idea that I created earlier today in my notifications. It states that the status has changed. But when I click on... https://community.smartsheet.com/discussion/91376/vlookup-issue-when-column-are-added-to Vlookup issue : When column are added to - Smartsheet Community Hi, I have successfully applied a Vlookup from reference sheet to my parent sheet. However, when a new column is added within that range in reference sheet... vlookupissuecolumnaddedsmartsheet https://ittrainingcontent.iu.edu/training/vlkup/files/pc/vlookup-absolute-references.html Using absolute cell references in the VLOOKUP function: IU Only: Files: Spreadsheets: Using VLOOKUP... Explore using absolute cell references in a VLOOKUP function. in the https://community.smartsheet.com/discussion/87676/help-with-vlookup-or-match-based-on-a-predecessor-row Help with vlookup or match based on a predecessor row - Smartsheet Community I'm fairly new with smartsheets and trying to build an automated system where the task ready box is checked when % complete column is marked 100% based on the... help withbased on https://techcommunity.microsoft.com/discussions/excelgeneral/ifs-with-vlookup-help/4405378 IFS with VLOOKUP help | Microsoft Community Hub IF(OR(IFERROR(IFS(AND(F3=VLOOKUP(F3,'Dropdown list'!N2),F4=VLOOKUP(F4,'Dropdown list'!N2)),"yes",AND(F3=VLOOKUP(F3,'Dropdown... microsoft communityifsvlookuphelphub https://techcommunity.microsoft.com/discussions/excelgeneral/auto-populate-different-cells-based-on-one-cells-value-and-not-have-vlookup-retu/3820018/replies/3820231 Auto populate different cells based on one cells value and not have VLOOKUP return #N?A if value... I am trying to have cells B6, B8 and B10 auto populate from the Data tab based on B4's input value. If the number in B4 matches what is in Data in column A,... https://techcommunity.microsoft.com/discussions/excelgeneral/using-vlookup-want-the-name-of-person-with-max-salary-in-east-zone/3734523 Using Vlookup want the name of person with max salary in east zone | Microsoft Community Hub I am having name column first name , last name then region column then salary column.. from this i want the person name who having max salary in east... https://techcommunity.microsoft.com/discussions/microsoft-365/vlookup-with-parenthesis-and-single-quotes/264698 VLOOKUP with parenthesis and single quotes | Microsoft Community Hub Hi All, I am trying to do a vlookup on a table that has parenthesis and single quotes. When I try to lookup data that I know is on the table, I get #N/A... single quotesmicrosoft communityvlookupparenthesishub https://excelsuperstar.org/ Learn Excel in Hindi | Excel Vlookup, Hlookup, Pivot Table in Hindi Aug 19, 2025 - Excelsuperstar help you to learn Excel in Hindi. Learn Excel Vlookup, Hlookup, 2D-Lookup, Pivot Table, Formulas and Function in Hindi learn excelin hindivlookuphlookuppivot https://community.smartsheet.com/discussion/109958/vlookup-help Vlookup Help - Smartsheet Community I want to pull data from sheet A (LNH Master Sheet) in a specific column (Closing Date) and move it to sheet B(Job Progress), column (Closing Date). Both... vlookuphelpsmartsheetcommunity https://community.smartsheet.com/discussion/82333/i-want-to-add-a-if-statement-to-a-simple-vlookup-that-checks-something-additional I want to add a IF statement to a simple vlookup that checks something additional. - Smartsheet... Does anyone have any suggestions on adding a IF to this current formula that would say IF "Approved" than "Excluded" else this would pull from another sheet or... i want to https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-functions-are-replaced-with-result-on-save/2646481/replies/4029826 vlookup functions are replaced with result on save | Microsoft Community Hub I have a file from a client saved in .xls format (I don't know which version of Excel) that has many vlookup functions in the file. Once I enter data... microsoft communityvlookupfunctionsreplaced https://market.tutorialspoint.com/course/excel-master-the-vlookup-formula-in-90-minutes/index.asp Excel Master the VLOOKUP Formula in 90 minutes! - Online Course excelmastervlookupformulaminutes https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-with-countif-and-range/4110331/replies/4110364 VLOOKUP WITH COUNTIF AND RANGE | Microsoft Community Hub I have an excel sheet that has several employee names for a 90 day period, it will show how many minutes late they were each day for 90 days. on... microsoft communityvlookupcountifrangehub https://kb.wisc.edu/helpdesk/feedback.php?action=2&help=suggest&id=1237 Feedback: Excel - Using the VLOOKUP and HLOOKUP Functions feedbackexcelusingvlookuphlookup https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-not-working-with-cell/216806/replies/216905 VLOOKUP not working with CELL | Microsoft Community Hub Hello, I'm having trouble with this project that I'm working on. I'm trying to make a report in which you chose a name from a drop down list and then... not workingmicrosoft communityvlookupcellhub https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-error-in-my-formula/4009924 VLOOKUP: Error in my formula | Microsoft Community Hub Coursework help: Im copying exactly as my teacher taught me lol but its presenting an error, any help? my formulamicrosoft communityvlookuperrorhub https://community.smartsheet.com/discussion/65886/blank-cell-when-no-data-is-yet-input-with-a-vlookup Blank cell when no data is yet input with a vlookup - Smartsheet Community I have a vlookup formula to calculate a return however, when there is no input yet, the cell is showing #no match, I would like it to be blank until the cell... https://community.smartsheet.com/discussion/45361/how-to-use-index-match-instead-of-vlookup-still-using-sheet-references How to use Index/Match instead of vlookup still using sheet references - Smartsheet Community Hello We have started to build a large master sheet using vlookups (mostly countifs and sumifs) cross referencing our other sheets but have quickly run into... how to use https://community.airtable.com/show-and-tell-15/find-arbitrary-item-in-lookup-array-like-vlookup-2003 Find Arbitrary Item in Lookup(array) - like Vlookup | Airtable Community Simple version (so you can cut and paste, and put to use) Link to demo base:TestLab Status Airtable TestLab Status - Airtable Exp... findarbitraryitemlookuparray https://trailhead.salesforce.com/ko/trailblazer-community/feed/0D54S00000A8CqGSAV What is the Function of VLOOKUP in | Salesforce Trailblazer Community hii guys, Can any one explain the functionality of VLookup in salesforce with good example.. what is thefunctionvlookupsalesforcetrailblazer https://community.smartsheet.com/discussion/75332/if-column-1-contains-yes-vlookup-data-from-column-2 If Column 1 contains "Yes", Vlookup data from Column 2. - Smartsheet Community Hi Community, I want to lookup data, based on data on my current sheet, If Column 1 contains "Yes", Vlookup data from Column 2. IF Column 1 CONTAINS "YES"... columncontainsyes https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup/3598165/replies/3598205 vlookup | Microsoft Community Hub I've never used vlookup. I have made a pivot table out of my information and I need to pull in information from another sheet. I can not seem to format this... microsoft communityvlookuphub https://techcommunity.microsoft.com/discussions/excelgeneral/help-with-vlookup--index-or-other/3584637 Help with vlookup / index or other | Microsoft Community Hub help withmicrosoft communityvlookupindexhub https://techcommunity.microsoft.com/discussions/excelgeneral/excel-vlookupif-assistance-/3791821 Excel VLOOKUP/IF Assistance. | Microsoft Community Hub Hello All, I have a longterm partner who was recently diagnosed with Diabetes due to fluctuating Blood Glucose levels. I am currently in the process of... microsoft communityexcelvlookupassistancehub https://ittraining.iu.edu/explore-topics/titles/vlkup/ Spreadsheets: Using the VLOOKUP function: All Titles: Explore topics: UITS IT Training: Indiana... Explore how to use VLOOKUP in Microsoft Excel and Google Sheets https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup/3972399 VLOOKUP | Microsoft Community Hub I receive date each month on funds, with their unit value. Beginning in June, the data I received came from a slightly different method, and now my... microsoft communityvlookuphub https://community.smartsheet.com/discussion/37951/vlookup-return-the-second-value-that-is-finds-in-the-table VLOOKUP return the second value that is finds in the table - Smartsheet Community Hi, I am looking for a formula that can return the first, second, third ... value in the table. Using Vlookup will only return the first match Any... the second https://community.smartsheet.com/discussion/27126/vlookup VLOOKUP - Smartsheet Community I am having difficulty with the VLOOKUP working. It will work one day and the next time I come back to the sheet it does not work. If I go and update the 1st... vlookupsmartsheetcommunity https://groups.google.com/g/mementodatabase/c/-gm0nVFVcRc JavaScript VLOOKUP javascriptvlookup https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-works-online-not-in-excel-software/3614188/replies/3614439 vlookup works online not in Excel software | Microsoft Community Hub vlookup formula works on the Excel Web App but not on the installed Excel software. We reinstalled Microsoft 365 but still not allowing me to use... works onlinesoftware microsoftvlookupexcelcommunity https://jones-msowc.catalog.instructure.com/browse/jc-directory/employability/courses/jc-mso-3001 Using VLOOKUP and HLOOKUP JC-MSO-3001 - Employability usingvlookuphlookupjcmso https://techcommunity.microsoft.com/discussions/excelgeneral/help-with-vlookup/3806732/replies/3806758 Help with VLookup | Microsoft Community Hub I'm trying to figure out how to write a proper VLOOKUP function that allows me to pull the proper multiplier from the table below based upon the user's... help withmicrosoft communityvlookuphub https://techcommunity.microsoft.com/discussions/excelgeneral/combining-right-function-with-vlookup-with-multiple-conditions/4129337/replies/4129349 Combining RIGHT function with VLOOKUP with multiple conditions | Microsoft Community Hub I am trying to write a function that will look up if the last character in A column is "D" or "L" and if this is the case will then move the last character... right functionmicrosoft communitycombiningvlookupmultiple https://community.smartsheet.com/discussion/76614/vlookup-functions-not-working-on-a-master-spreadsheet Vlookup functions not working on a Master Spreadsheet - Smartsheet Community My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup... not workingon avlookupfunctionsmaster https://techcommunity.microsoft.com/tag/vlookup?nodeId=board%3AExcelGeneral Tag:"vlookup" in "Excel" | Microsoft Community Hub Find all posts, articles, and events tagged with "vlookup" within Excel in Microsoft Community Hub. Stay informed with the latest updates from our community microsoft communitytagvlookupexcelhub https://community.smartsheet.com/discussion/93681/how-do-i-fix-a-vlookup-problem How do I fix a VLOOKUP problem? - Smartsheet Community Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the... how do ifixvlookupproblemsmartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-not-working-properly/168270 Vlookup not working properly | Microsoft Community Hub I'm a novice user, and this is my first post, so not sure i'm even doing this right. I feel I have my formulas right and Vlookup is not pulling the... not workingmicrosoft communityvlookupproperlyhub https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-not-working-in-large-file/3555852/replies/3555969 Vlookup not working in large file | Microsoft Community Hub I am doing a vlookup comparing two large files (200,000+ rows). The data I'm doing to vlookup on are in the number format. The vlookup will return... not workinglarge filemicrosoft communityvlookuphub https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-link-to-unshared-file-in-dropbox/219511 Vlookup link to unshared file in Dropbox | Microsoft Community Hub Hello, I have a "master file" that is not shared on Dropbox. The master file cannot be shared due to sensitive info. I need to share a... link tomicrosoft communityvlookupfiledropbox https://techcommunity.microsoft.com/discussions/excelgeneral/confirming-if-a-cell-matches-another-using-a-vlookup/631884 Confirming if a cell matches another using a vlookup | Microsoft Community Hub Hey guys, Just looking for some assistance with pulling data from one cell into another - the example would be as follows:Cell A1: ABC BrisbaneCell B1:... microsoft communityconfirmingcellmatches https://community.smartsheet.com/discussion/46926/vlookup-or-index-with-match Vlookup or Index with Match? - Smartsheet Community Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the... vlookupindexmatchsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-not-selecting-first-cell-from-top-/3714466/replies/3717017 Vlookup not selecting first cell from top. | Microsoft Community Hub Hi, I have a table with more than one match for the Lookup_value. If there are four matches, then the result returned is from the last match found... microsoft communityvlookupselectingfirstcell https://techcommunity.microsoft.com/discussions/excelgeneral/complicated-vlookup-example/4144478 Complicated vlookup example | Microsoft Community Hub Hi there, I have a dataset where there are three different columns with names. I would like VLOOKUP or INDEX, etc to use those names (in 3... microsoft communitycomplicatedvlookupexamplehub https://community.smartsheet.com/discussion/72620/column-formula-with-vlookup-using-external-reference Column Formula with VLOOKUP using External Reference - Smartsheet Community I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses... external referencecolumnformulavlookupusing https://elearning.bmh.manchester.ac.uk/administrators/vlookup/ Using Excel to VLookup Data Between Systems - Technology Enhanced Learning and Design Nov 14, 2025 - Many Administrators across the Faculty come across a problem whereby they need to match a piece of information to another piece of information quickly across... technology enhanced learning https://community.smartsheet.com/discussion/104413/if-vlookup-index-match-collect IF/VLOOKUP/INDEX/MATCH/COLLECT - Smartsheet Community Hi all, I have a weekly form that is required to be submitted each week a manager is in training through certification. I am working with two sheets: (1) MIT... vlookupindexmatchcollectsmartsheet https://community.smartsheet.com/discussion/82713/index-collect-or-vlookup-not-working-with-numbers INDEX COLLECT or VLOOKUP not working with numbers - Smartsheet Community I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By... working with numbersindexcollectvlookupsmartsheet https://techcommunity.microsoft.com/discussions/excelgeneral/excel-vlookup--if--textbefore/3704298 Excel Vlookup / IF / Textbefore | Microsoft Community Hub Hi all;I have been going along well on a sheet, but I have hit a roadblock and I am hoping it is obvious to someone here. What I have in the first line... microsoft communityexcelvlookuptextbeforehub https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-help/309342 Vlookup help | Microsoft Community Hub Hello all, so i'm currently working with the following table: ab1AmountWeight2Code"Enter... microsoft communityvlookuphelphub https://techcommunity.microsoft.com/discussions/excelgeneral/how-to-find-the-vlookup/3674227/replies/3674288 How to find the Vlookup | Microsoft Community Hub Here the Code is not pickup.please refer the attached excel sheet. how to findmicrosoft communityvlookuphub https://community.smartsheet.com/discussion/76099/can-i-use-vlookup-if-what-i-am-looking-up-is-a-range-of-dates Can I use VLookUp if what I am looking up is a range of dates? - Smartsheet Community I need to cross check an entry in my smartsheet with a range of dates against another sheet. I am able to do a Vlookup for start date (first pic below) but am... https://www.w3schools.com/excel/excel_vlookup.php Excel VLOOKUP Function Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and... excelvlookupfunction https://community.smartsheet.com/discussion/58246/sumifs-vlookup-or-date-range Sumifs, vlookup, or date range - Smartsheet Community Hey I have some difficulty figuring out how to write a formula for my problem. My scenario is as follows: I have to sheets (see attached): * Payment sheet *... date rangesumifsvlookupsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-help/275878 VLookup help | Microsoft Community Hub Who is up for a challenge?I have created a spreadsheet that has worked perfectly up to this point.Today I was asked to add our Disney collection to this... microsoft communityvlookuphelphub https://trailhead.salesforce.com/pt-BR/trailblazer-community/feed/0D54S00000A8CqGSAV What is the Function of VLOOKUP in | Salesforce Trailblazer Community hii guys, Can any one explain the functionality of VLookup in salesforce with good example.. what is thefunctionvlookupsalesforcetrailblazer https://community.smartsheet.com/discussion/49801/vlookup-with-multiple-requirements VLookup with multiple requirements - Smartsheet Community I have read several community threads already, and can't seem to find what i am looking for. I have a Vlookup table that includes Pipe Type (Copper or SCH 40),... vlookupmultiplerequirementssmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-or-some-other-formula-help-needed/188215 Vlookup or some other formula Help Needed | Microsoft Community Hub Hi there, I have two excel files. One is source file and second target. From source file I want to copy Test Score column values to Target file's Test... other formulahelp neededmicrosoft communityvlookuphub https://expand.iu.edu/browse/ittraining/single/courses/vlkup Spreadsheets: Using the VLOOKUP Function (IT Training) - UITS IT Training - Single Courses it trainingspreadsheetsusingvlookupfunction https://community.smartsheet.com/discussion/21351/cannot-delete-ref-links-from-vlookup cannot delete ref links from vlookup - Smartsheet Community Hi I tested vlookup function and I created a new sheet .I deleted this new sheet but now in my master sheet it's still outbound to ref unknown sheet. I cannot... cannotdeletereflinksvlookup https://community.smartsheet.com/discussion/82618/vlookup VLOOKUP - Smartsheet Community Column1 Column2 Column3 1 1/1/20 Complete 3 1/1/20 Pending 2 1/1/20 Pending Column 4 Column5 Column6 3 1/1/20 Complete 2 1/1/20 Pending 1 1/1/20 Complete I... vlookupsmartsheetcommunity https://community.smartsheet.com/discussion/33621/sumifs-with-vlookup SUMIFS with VLOOKUP - Smartsheet Community On a sheet I call "Project Group Hour Totals", I am trying to add the hours from a sheet I call "Project Time Tracker", using VLOOKUP to find both my Project... sumifsvlookupsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-not-returning-correct-value/131188 vlookup not returning correct value | Microsoft Community Hub Hello, Novice with Vlookup - I really thought I had this but this formula keeps producing the wrong value. What am I doing wrong? Thanks... microsoft communityvlookupreturningcorrectvalue https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-from-a-co-authored-document-to-a-document-on-a-server/3762093/replies/3762112 vlookup from a co-authored document to a document on a server | Microsoft Community Hub I have recently shared an excel document via Co-Authoring, although access is great, I have some Users that vlookup to documents saved on our server or... https://community.smartsheet.com/discussion/68433/vlookup-with-duplicate-data VLOOKUP with Duplicate Data - Smartsheet Community I have a master sheet that may have duplicated column data, like: Client Name | Status (dropdown) | Delivery Date | Feature (checkbox) Client A | Rescheduled |... vlookupduplicatedatasmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/vlookup-or-another-formula-needed/3559764 VLOOKUP or another formula needed | Microsoft Community Hub Hi everyone. I need help with a formula, possibly a VLOOKUP? In the below example, I need to search and find matches from Column A and Column... microsoft communityvlookupanotherformulaneeded https://community.smartsheet.com/discussion/47006/vlookup-reference-another-sheet-with-parents VLOOKUP reference another sheet with parents - Smartsheet Community We are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date... vlookupreferenceanothersheetparents https://community.smartsheet.com/discussion/67486/vlookup-with-multi-select-column VLOOKUP with Multi-Select Column - Smartsheet Community This discussion was created from comments split from: Announcing Formula Support for Contact Columns. multi selectvlookupcolumnsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/ms-excel---vlookup-result-is-not-calculated-automatically/463531 MS Excel - VLOOKUP result is not calculated automatically | Microsoft Community Hub I have an application that generates a file that include VLOOKUP formulas, but the result is not calculated automatically. I need to manually press F2 +... ms excelmicrosoft communityvlookupresult https://community.smartsheet.com/discussion/50991/vlookup-limitation-of-25000-cells Vlookup limitation of 25000 cells - Smartsheet Community Can anyone help me to rectify the error as I am using cross sheet vlookup function in Smartsheet to extract some information, while doing this I am facing the... vlookuplimitationcellssmartsheetcommunity https://community.smartsheet.com/discussion/34956/vlookup-help vlookup help - Smartsheet Community OK....so I am struggling with this vlookup. Perhaps I can not do what I want to do. Any comments would be helpful. I have a sheet that has customer number and... vlookuphelpsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/conditional-vlookup/3816328 Conditional Vlookup | Microsoft Community Hub Hello All, I am trying to perform a conditional vlookup based on values. For example, I want to fetch server name from another sheet and only want to... microsoft communityconditionalvlookuphub https://community.smartsheet.com/discussion/70485/beyond-vlookup-report Beyond Vlookup ... Report? - Smartsheet Community Hi All, I'm in a bit of a situation and I'm looking for ideas... I have a .csv that I import into smartsheet. It is quite a big file that contains a lot of... beyondvlookupreportsmartsheetcommunity https://community.smartsheet.com/discussion/77087/vlookup-dates-that-fall-within-a-range VLOOKUP dates that fall within a range - Smartsheet Community I created a sheet to populate inspection dates by cross referencing (VLOOKUP) the license plate number from the inspection record sheet. The tracking sheet... a rangevlookupdatesfallwithin https://community.smartsheet.com/discussion/65146/proper-syntax-for-if-and-vlookup Proper Syntax for IF and VLOOKUP - Smartsheet Community propersyntaxvlookupsmartsheetcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/how-do-make-index-match-or-vlookup-grab-the-latest-value/3992705 How do make index Match or VLookup grab the latest value | Microsoft Community Hub Hi there everyone, I have a question regarding these functions mentioned above. I have a worksheet, which i cant show for confidentiality purposes, but i... https://dlab.berkeley.edu/events/excel-data-analysis-charts-pivot-tables-and-vlookup/2024-02-29 Excel Data Analysis: Charts, Pivot Tables, and VLOOKUP | D-Lab excel data analysispivot tableschartsvlookuplab https://community.smartsheet.com/discussion/82207/vlookup-or-index-match-look-up-help Vlookup or Index Match look up help - Smartsheet Community Hello, I feel like this is an easy question, but I have been struggling to find the answer in a way I can understand. Basically, I need to use a vlook up or... look upvlookupindexmatchhelp https://community.smartsheet.com/discussion/81234/is-it-possible-to-set-up-a-card-view-lanes-based-on-a-column-based-on-a-vlookup-value Is it possible to set up a card view lanes based on a column based on a vlookup value? - Smartsheet... I'm trying to layout my card view by launch quarter/year. I currently select the launch quarter/year by using a drop down menu based on the estimated launch... https://techcommunity.microsoft.com/discussions/excelgeneral/if--vlookup-funtion-ifvlookupd2data-directorya24a4291-falsed2-old-new/3603046/replies/3603054 IF & Vlookup funtion: =IF(VLOOKUP(D2,Data_Directory!$A$24:$A$429,1, FALSE)=D2, "OLD", "NEW") |... Hey guys, I am trying to say if we can find the value "D2" in the data directory sheet in the rows A24 through A429 then the output value should... https://community.smartsheet.com/discussion/128771/vlookup-formula-help Vlookup formula help - Smartsheet Community Hello - I created a summary sheet using the vlookup formula referencing another sheet. However, how do I show two amounts from two different rows in the source... vlookupformulahelpsmartsheetcommunity https://community.smartsheet.com/discussion/107222/sheet-summary-same-sheet-vlookup-with-today Sheet Summary - same sheet VLOOKUP with TODAY() - Smartsheet Community Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a... sheetsummaryvlookuptodaycommunity https://chromewebstore.google.com/detail/sheets-vlookup-formula-bu/pomnolmgnkpaakfaklcokokedgdcfalc?hl=en-GB Sheets VLOOKUP Formula Builder - Chrome Web Store Build a Google Sheets IFERROR+VLOOKUP formula from your inputs. sheetsvlookupformulabuilderchrome