how to call same row data from different table?

[rnmishra90]

i have two different tables, first table "pending" and another one is "planning". pending table has 3 column [lot no],[item name], [qty]. there is a list of pending items and qty. now come to second table "planning", here is 10 column, [item name], [lot no], [qty] etc, when is select item name in planning table it shows the list of item name of 1st table, when i select an item from the list, i want the data in 1st table pending lot no and qty may fill automatically with selected row of item name. we can not use look up because same item name multiple time in that table . i want data specifically from selected item name.

[lynchk21]

Here is my understanding of your issue, please correct me if it is wrong. You have two tables:

Pending Table:

• [Lot no]
• [item name]
• [qty]
• etc

Planning Table

• [item name]
• [lot no]
• [qty]

Planning[item name] is a list of values from the Pending[item name] column. When selecting Planning[item name], you want the values from Pending[lot no] and Pending[qty] to autopopulate in the Planning[lot no] and Planning[qty] column based on the selected [item name].

However, your Pending[item name] column contains multi rows with the same [item name], so you cannot use LOOKUP() on your Planning table to retrieve the values you need. Correct?

 What is your reference column between the two tables?

Perhaps you could provide screenshots of your data tables to help the community understand.