0

I have a table (table1) then is my data table same as below Table1

and I have a form then that have a table inside it same as below Form

I need when I enter the "POD" from "Table1" in "POD"(B1) in "Form", the "Table2"(inside "Form") fill by data from "Table1". this may 1 row or multi row data. and I don't need all columns from "Table1"

Thanks for your solution Best Regards

I try Xlookup , match, find, filter and anything I know but I didn't find anything

Improve this question
6
  • What's the version you tried using FILTER? What did it return versus what you expected it to return? Commented Jan 15, 2024 at 9:04
  • @P.b I'm using 2021. did u see picture? I tried FILTER but :( Commented Jan 15, 2024 at 9:21
  • @P.b I need any columns of data. but FILTER return all columns Commented Jan 15, 2024 at 9:25
  • So you answered what it returned, what you expected from it, but not what the formula was you used. And yes I did see the picture, but I'm surprised you say your formula returned all, since you're using a table which doesn't allow spilling. Therefore, be more descriptive and we can help. Commented Jan 15, 2024 at 11:13
  • 1
    Please update your question (using edit) to include your formula you tried (especially the one using FILTER). And explain what it returned and what you expected it to return. Commented Jan 15, 2024 at 13:18
Related questions
0
Xlookup and return value not from the same row
0
Appending rows of data from one Excel table to another
0
How to multiply two numbers based on 3 separate criteria in a table?
Load 2 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.