Hi,
I am wanting to pick up some information from a single formula from 2 different rows/columns.
For example i have in column A:A random number and Column D:D i have periods
I am wanting to pull in column E the values of A3 and D3 for example into cell E3 from the table on another sheet.
The table has all the codes from Column A in the B Column
The table has all the codes from Column D in the 1 row.
all the data i am wanitng is if the cell i am wanting matches B and 1 then pull from I2:T33
I have tried this and just getting an error
=XLOOKUP(A3&D3,'Forecast From Buyers'!B2:B33&'Forecast From Buyers'!I1:T1,'Forecast From Buyers'!I2:T33)
I have also tried xlookup(1, etc but getting exceld doesnt have enough memory to fulfill the request.
can you advise
thanks
I am wanting to pick up some information from a single formula from 2 different rows/columns.
For example i have in column A:A random number and Column D:D i have periods
I am wanting to pull in column E the values of A3 and D3 for example into cell E3 from the table on another sheet.
The table has all the codes from Column A in the B Column
The table has all the codes from Column D in the 1 row.
all the data i am wanitng is if the cell i am wanting matches B and 1 then pull from I2:T33
I have tried this and just getting an error
=XLOOKUP(A3&D3,'Forecast From Buyers'!B2:B33&'Forecast From Buyers'!I1:T1,'Forecast From Buyers'!I2:T33)
I have also tried xlookup(1, etc but getting exceld doesnt have enough memory to fulfill the request.
can you advise
thanks