Page 1 of 1
lookup value from another sheet
Posted: Wed Mar 15, 2023 11:39 am
by sna
Hi there
i need your help how to write formula to get the value from column F .there're many sale persons in the report
so i need to get total value from all sales people on another sheet because report in sheet0 always update
thanks
Re: lookup value from another sheet
Posted: Wed Mar 15, 2023 1:52 pm
by norkaz
..
Hi guy,
I'm not quite sure what exactly the results you need.
I guess the last cell in column F is the exact number that you need for the output result.
If yes, the lookup function would be better to solve that.
=LOOKUP(10^10,Sheet0!F:F)
Norkaz
Re: lookup value from another sheet
Posted: Thu Mar 16, 2023 1:32 pm
by sna
Hi Norkaz ,
It is working but how another column because it has ,so we need to use SUMIFS .for example column AD because data update daily so I don't want to sum then lookup.
Thanks
Re: lookup value from another sheet
Posted: Thu Mar 16, 2023 2:23 pm
by norkaz
...
Hi guy,
To make something clear, please help to give us
1) The attached Excel file
+ 2) The sample answers that you need
+ 3) The criteria for that...
Norkaz