Is there any option to display the values from another sheet?

31 Views Asked by At

i want to display the value in another sheet by a solution. so that when we enter a code it must search from the last sheet and generate value. pls check

1

There are 1 best solutions below

0
On

should be:

=ARRAYFORMULA(IFERROR(VLOOKUP(A2:A10, QUERY(
 {'Please Solve'!$A$2:$B$10;'Please Solve'!$C$2:$D$10},
 "select Col1,Col2 where Col1 <>'' order by Col1,Col2 ", 0), 2, 0)))

0