I am trying to use a vlookup / index to pull some numbers. Sample data attached: A: merged cells (the number is stored in the top of cell of the merge) B: Only
I've been looking for different approaches to fix my problem, whether it's with vlookup, index, index /match but couldn't figure it out yet. I'm trying to list
I have created three google sheets wherein one google sheet is designed as the Masterfile for the data present on the two other google sheets. I was able to mer
Example Spreadsheet Current formula not returning values as desired: =IFERROR(ifNA(min(arrayformula(index(D2:I2, match(INDEX(FLATTEN(split(A2, ", ", FALSE)&
I'm trying to get the values for column C in Table 1 from column H by using vlookup. However, seems like the vlookup doesn't work and return a N/A. I had check
Using an Excel formula, I'm trying to pull the MAX value for a NAME that has a certain LETTER next to it. Eg: Highest # for a specific % for each unique Name
I'm getting a strange #N/A error excel/vlookup. I have a database connection with sql query returning a lot of rows ~40k. I have a field with two data values se
I'm using MS Excel O365 Business in version 1905 (compilation 11629.20196). In this case i have created two sheets: 1) "Orders" 2) Order_status NUMBER_ORD
I am trying to create an if-vlookup that retrieves data from 2 sheets with following specs: if the retrieve from the 1st sheet shows N/A and 0 results than vloo
I have two sheets that I want to link using a "primary key". At the moment, I have imported from sheet1 into sheet2 some columns using the function =Sheet1!A1
I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe
I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe
I have an array of 30 columns and 800 rows (Sheet 1), each cell has either text or is blank. I want to check if ANY values in this array (specificially row by r
I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da
I have 2 workbooks....OdysseyDeposit where my source data is and Civil Bank Accnt Recon which contains VLOOKUP to the OdysseyDeposit. Here is the VLOOKUP funct