Find data from a table using 4 inputs

**Frankie_The_Flyer** · 05-12-2022, 01:21 AM

Hi

(Difficult to title this one!)

Please see attached workbook. I have a table of Inputs (sheet "Inputs") which has rows of 4 numbers across 6 possible columns (Two always blank) and a number in the 7th column that I want to retrieve.

On the sheet "Check" I'd select 4 different numbers from a long drop down list. I then need to be able to click on the "Check Button" and for excel to search for the row in the Sheet "Inputs" where those four numbers are together, in any order, across the row, and return the value in the 7th column (Best Number) in that row to show in cell G2 on the sheet "Check".

The for numbers currently selected are definitely in a row in the sheet "inputs" and I've pasted a copy of the numbers in cells S2:V2 so you can get them back if you change the drop down numbers.

A really nice finish would be a message box that says "This selection of numbers has not been entered yet" if the search draws a blank.

Many thanks

Frankie

**JohnTopley** · 05-12-2022, 03:00 AM

Will a "Check "value only appear once in Input i.e. in only ONE of the 6 columns? Your posted file only has a single occurrence of each.

**Sintek** · 05-12-2022, 03:34 AM

One way...With a helper column...

Please Login or Register  to view this content.

**JohnTopley** · 05-12-2022, 09:28 AM

@Sintek: Fallen at the first hurdle!

This only works if the "Check" values (helper column) are in the same sequence as the Input column data

Input: 609C/2967A/44E/3012A vs "Check": 609C/44E/3012A/2967A for match on row 47.

**JohnTopley** · 05-12-2022, 09:31 AM

Please Login or Register  to view this content.

**Sintek** · 05-12-2022, 09:45 AM

@ John...Got confused at your response until I only NOW noticed this...

where those four numbers are together, in any order, across the row

Oops...My bad...Yep, fallen hard lol...

**JohnTopley** · 05-12-2022, 10:25 AM

@ Sintek: equally my offering will fail if a "check" value occurs more than once in a given column (as I use MATCH).

Pick yourself up, dust yourself down and off you go!!!

**Sintek** · 05-12-2022, 11:04 AM

Pick yourself up, dust yourself down and off you go!!!

True...I will revisit this a bit later...
For you...Just a heads up...6 + variables not declared...
Add Option Explicit to top of your code and run...

**Bo_Ry** · 05-12-2022, 11:56 AM

Please try

Please Login or Register  to view this content.

**Frankie_The_Flyer** · 05-12-2022, 09:49 PM

Hi Folks

Thank you everyone for giving this a go. Great to see so many rising to the challenge!

Special thanks to Bo_Ry who seems to have cracked it quite simply in the end!!

Now on to the next bit of the puzzle.

Cheers

Frankie

Find data from a table using 4 inputs

LinkBack

Thread Tools

Rate This Thread

Display

Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Re: Find data from a table using 4 inputs

Thread Information

Users Browsing this Thread

Similar Threads

Variable row and column inputs y data table

Data table - two inputs that are variables

Data table with 2 rows of inputs

Create a data table by varying inputs

[SOLVED] how do i get my data table column inputs to work?

Find value in table based on two inputs

[SOLVED] Can Row and Column Inputs in 2 Var. Data Table be on a separate sh

Bookmarks

Bookmarks

Posting Permissions