Help with vlookup and returning a value in a different row

[devenm1015]

Ok so I am not sure where I am going wrong here. I am trying to use the current excel sheet and format another manager is using so it does not disrupt what he is already doing. Basically, I need to have the look up value be the date and then return the Pellet quantity in the third column to one location and the extruded quantity also in the third column to a different location. With vlookup only allowing me to have the data in the same row I am not sure how to go about doing this. Anyone have any thoughts? I would greatly appreciate some help here. LOL

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, please consider XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

Is it something like this that you are after?

23 08 20.xlsm
	A	B	C	D	E	F	G	H	I
1							Date	Pellet	Extruded
2	25/07/2023	Pellet	1	2	3		25/07/2023	1	4
3		Extruded	4	5	6		26/07/2023	7	10
4		Total
5
6	26/07/2023	Pellet	7	8	9
7		Extruded	10	11	12
8		Total
9
10
Lookup

Cell Formulas
Range	Formula
H2:H3	H2	=XLOOKUP(G2,A$2:A$20,C$2:C$20)
I2:I3	I2	=XLOOKUP(G2,A$2:A$20,C$3:C$21)

 

[devenm1015]

It does not seem to be working for me. I cannot use the mini sheet because my company's security things on my computer do not allow me to download or use any addons. Here is a screen shot. I can get the data in the immediate row to return but for some reason I cannot get the xlook up to return for the extruder bags each day

 

[Peter_SSs]

Unfortunately, from the image I cannot see/know

• what rows/columns the data is in
• what rows/columns formulas are in
• what each formula is
• what 1st Shift means - that wasn't mentioned before.
• what the expected results are

I am also confused about the dates. I had assumed that your dates are m/d/y format, please confirm or correct me.
If I am correct about that then 8/3/2023 is a Thursday yet it seems for Bags Packed you have 2382 from the 8/3/2023 section (Thursday?) listed beside Mon.
A lot more clarification is required.

As well as the clarification, perhaps you could upload a small dummy example like shown, but with any working formulas included and any other required results filled in manually, to one of OneDrive, Google Drive, DropBox etc and provide a public shared link here? Having that sample and your further explanation may make things clearer.

 

[devenm1015]

https://landolakes-my.sharepoint.com/❌/p/dmoss/EaH5uk4_VFhJtT54Wp5lTn4B3lM4xiNV9qHchlyjNHzoKw

see if you can access this link.

 

[devenm1015]

see if you can access this link.

https://landolakes-my.sharepoint.com/❌/p/dmoss/EaH5uk4_VFhJtT54Wp5lTn4B3lM4xiNV9qHchlyjNHzoKw

 

[devenm1015]

https://landolakes-my.sharepoint.co...FCgrdnT97RV-UBlUTt2BKWCb1je7vmvxMt6w?e=ipZw0d

 

[devenm1015]

Unfortunately, from the image I cannot see/know

• what rows/columns the data is in
• what rows/columns formulas are in
• what each formula is
• what 1st Shift means - that wasn't mentioned before.
• what the expected results are

I am also confused about the dates. I had assumed that your dates are m/d/y format, please confirm or correct me.
If I am correct about that then 8/3/2023 is a Thursday yet it seems for Bags Packed you have 2382 from the 8/3/2023 section (Thursday?) listed beside Mon.
A lot more clarification is required.

As well as the clarification, perhaps you could upload a small dummy example like shown, but with any working formulas included and any other required results filled in manually, to one of OneDrive, Google Drive, DropBox etc and provide a public shared link here? Having that sample and your further explanation may make things clearer.

https://landolakes-my.sharepoint.co...FCgrdnT97RV-UBlUTt2BKWCb1je7vmvxMt6w?e=ipZw0d

 

[devenm1015]

Unfortunately, from the image I cannot see/know

• what rows/columns the data is in
• what rows/columns formulas are in
• what each formula is
• what 1st Shift means - that wasn't mentioned before.
• what the expected results are

I am also confused about the dates. I had assumed that your dates are m/d/y format, please confirm or correct me.
If I am correct about that then 8/3/2023 is a Thursday yet it seems for Bags Packed you have 2382 from the 8/3/2023 section (Thursday?) listed beside Mon.
A lot more clarification is required.

As well as the clarification, perhaps you could upload a small dummy example like shown, but with any working formulas included and any other required results filled in manually, to one of OneDrive, Google Drive, DropBox etc and provide a public shared link here? Having that sample and your further explanation may make things clearer.

uploadthis.xlsx

Shared with Dropbox

www.dropbox.com

 

[devenm1015]

uploadthis.xlsx

Shared with Dropbox

www.dropbox.com

ok that link for drop box actually worked the others did not. sorry for the extra posts. Basically, i need to return the yellow highlighted data for 1st 2nd and 3rd shift extruded bags packed and then the mixing tons for all three shifts hightlightd in light blue. all based on the date.