Finding data from Table 1 with various variables to enter the correct value in table 2

**TAZTAZTIC** · 03-18-2024, 02:23 PM

Hello,

I have an issue that is bugging me and I've added an example of what I need help with.

I want to look up the data in Table 1 to enter the correct values in Table 2. What is the easiest way of doing this?

Is there a formula to do this?

I have attached a screenshot and the spreadsheet file

Can anyone solve this for me?

Thanks

**CARACALLA** · 03-19-2024, 12:34 AM

H4=IFERROR(INDEX(TEXTBEFORE($D$4:$D$100,"-"),MATCH($G4&H$3,INDEX($B$4:$B$100&$C$4:$C$100,),0)),"")

Copy across and down

**ORoos** · 03-19-2024, 12:47 AM

Try in 'H4' (copy across & down);

Formula:

Please Login or Register  to view this content.

**josephteh** · 03-19-2024, 01:23 AM

Spill formula in H4:
=IFERROR(TEXTBEFORE(XLOOKUP(G4:G8&H3:O3,B4:B42&C4:C42,D4:D42)," -"),"")

**TAZTAZTIC** · 06-04-2024, 10:47 AM

Thanks, everyone...this has been really helpful!

**AliGW** · 06-04-2024, 11:35 AM

Glad to have helped.

If you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Finding data from Table 1 with various variables to enter the correct value in table 2

LinkBack

Thread Tools

Rate This Thread

Display

Finding data from Table 1 with various variables to enter the correct value in table 2

Re: Finding data from Table 1 with various variables to enter the correct value in table 2

Re: Finding data from Table 1 with various variables to enter the correct value in table 2

Re: Finding data from Table 1 with various variables to enter the correct value in table 2

Re: Finding data from Table 1 with various variables to enter the correct value in table 2

Re: Finding data from Table 1 with various variables to enter the correct value in table 2

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Finding Multiple Variables in a Table

Error: One-Way Data Table / Sensitivity Table: Only correct value is current input!

[SOLVED] userform search field from 1 table and enter data into another table

How to use lookup/match/index in a table using variables to find the correct value

finding specific data from one table and pasting it into another table

Create a new table from the main table when user press Enter button

Finding, Counting, and Summing Multiple Variables in a Data Table

Bookmarks

Bookmarks

Posting Permissions