Excel Forum

More Xlookup/match?

Guest

Guests

July 17, 2024 - 9:39 pm

Hi,

I am struggling to pull Unit values from one table into another.

COSTOS table has details of unit costs by year, enterprise and item - (highlighted in magenta)

I am trying to pull the unit costs into COSTOS_DATA table having matched the enterprise, item and year (highlighted in yellow)

I know this will seem obvious to some but having only used excel in all the ways mynda says one shouldn't, I just dont find this intuitive.

Once again, any help would be greatly appreciated

Best regards

Nick

See Answer

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Moderators

Forum Posts: 1053

Member Since:
January 31, 2022

Offline

July 18, 2024 - 1:03 am

The COSTOS table is in the wrong format you should get it into a the shape as shown in the attached file. But then, the DATA table has Year and Month in it for three rows all Social farm & Staff. What is it that you would like to pick-up in the yellow cells?

Guest

Guests

July 19, 2024 - 4:04 am

Hi Riny

Thanks so much for your reply and putting the COSTOS table into the correct format - it is so obvious now I look at it.

Apologies for my slow response - I have been away from my desk since I posted yesterday.

I am trying to pull the relevant 'unit' data into the COSTOS_DATA table depending on the year, enterprise and item, then I can take quantities from another table and come up with an amount.

I hope that makes sense

Best regards and thanks again