May 19, 2018 · Vlookups in OneDrive I am trying to do simple vlookups from one shared document to another, but it is not working. is there a way to do this?

The first column of cal_rng is a date series (increment = 1 day) from 9/9/15 to 3/31/20. So, why does this VLOOKUP formula simply not find the correct row with the date 5/8/19 in column 1 …

Aug 6, 2010 · I have a workbook and I'm trying to use the VLOOKUP function. For some cells I get #N/A, others I get #REF!. =VLOOKUP(F733,URL!D2:D1705,11) I would like my formula to …

Dec 18, 2021 · Drag Copy VLOOKUP Array NOT updating I want to drag copy for multiple choice test. VLOOKUP is useful as well as Drag Copy. The final result, might be for example Who …

Jul 3, 2025 · My IFERROR+VLOOKUP combo returned the values Column AB correctly: =IFERROR (VLOOKUP (AA2;Y:Z;2;FALSE);"none"). I need to highlight those values in …

I am working on an insurance class code lookup tool and I am using a combo box as a drop down to select a description of certain risks. I am looking to make this box do a "fuzzy search." If you …

Apr 26, 2018 · I have a long list of formulas which use a vlookup to other workbooks. I wanted to change the date in the name of the workbook being refereced in the formulas so I tried that by …

Jun 13, 2023 · When does this message appear? What action seems to trigger it? Does it only appear when using Word or does it appear when using other programs as well? I'm not sure …

Dec 15, 2010 · I use vlookup all the time using arrays but seem stuck on this one. I want to lookup a value using the code number and if the date in B1 is less than or equal to a date on another …

I am looking for an excel formula that will have the email address in column H to find the same address in column F and place it on the same row next to it in column G.