Data selection and column info

Hi

Using a borrowed code with a bit of tweaking I'm trying to look up a particular "Input" name selected from the drop down list on Sheet1 B18 to find the data in the column beside it on Sheet2 columns A:D.

So far I've managed to get the code to list the number (Sheet2 column A) and the data beside the selected Input name and place them in column A & B in Sheet3 which is fine.

However, I need Sheet3 column C to then show the header of the column (Sheet2 C1 or D1) the Input Name from Sheet1 B18 is in for that result.

Currently the code shows data from Sheet2 C2 or D2 for the wrong column.

Code is in Module "Sort_From_Selection"

Thanks in advance!

Frankie

Sheet2!F2;
=GetResult(Sheet1!B18,Sheet2!A1:D37,FALSE,1)
Where
GetResult(Search value,Data Range,[DeleteSpace True/Fase, Default = False],[CompareMode 0/1, Deault = 1,case insensitive])

Please Login or Register  to view this content.

Thanks both! Got it working as required.

Great job!!

Cheers

Frankie