XLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and have the last three fields populate. Now, I can get this to work for one, but not the other and for some reason when I switch from bottom search to the top search the old data doesn't clear and the search doesn't work. This is the formula I have so far //=XLOOKUP(H8,A2:A10606,B2:B10606) Anything I have done after has been a disaster
#Connect Error in Excel for StockHistory Function
Evening, I am an O365 subscriber and am trying to set up an Excel sheet as a VAR template, and I wanted to populate my workbook with some historical data without uploading a CSV. Figured I would try out the StockHistory function. I keep getting "#connect" for my cells, and I am not sure why. I am not in developer mode, do not have any crazy add-ins, I am signed in, and connected to the internet. Do I need to be connected to a source? I am fairly new to learning about the StockHistory Function. Any thoughts on the matter are welcome. I tried all that I could from this site below: https://support.microsoft.com/en-us/office/how-to-correct-a-connect-error-584f7de9-b238-480c-8e8f-de0ba2c1aac9Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.
Cell Use from one sheet to Another
Hello. I have a multi-page workbook that requires using cells from one sheet on other sheets in the same workbook. I have one instance that in trying to work it out, has caused a second issue. When I try to add the cell from the one sheet to the next sheet using +=, then clicking on the sheet and cell to acquire it, when it posts is a 0. In trying to solve my issue and going to the sheet and cell in question, this is what I see. Highlighted cell. So, initially I was able to total that column. Now I can't because it no produceds a 0. It seems for some reason that cell does not show as =+'Wages'!G15, if I manually input that in the cell I need it in (on the other sheet) it still posts as 0. The source sheet for Wages is below this sheet. Can anyone help me get this worked out so I can use the required cell on the sheet i need to use it on?Formula Help
I have a spreadsheet I use for bidding construction work. On items 1-40 the formula in cells G22-G65 work like they are supposed to. From G66 to G88 where the sheet stops, the formula returns #NAME?. I've checked the formula from G65 to G66 and below, and they appear to be correct. I can't figure out what the problem is. This is the formula that works. =IF(D65>0,'40'!Rate+$G$18,0) This is the formula that does not work. =IF(D66>0,'41'!Rate+$G$18,0) The '40' and '41' refer to individual sheets within the workbook that contain the data in the !Rate cell. I've been looking at this for hours and can't figure it out. Any help or advice would be great.
Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!
