reverse lookup

I want to return the relative name from column A in cell B16 if the data set = "ORS". I wrote the following formula and it works fine. =@IF(COUNTIF($B$6:$D$13,"ORS")>1,"Check Call Schedule",INDEX($A$6:$A$13,SUMPRODUCT(($B$6:$D$13="ORS")*(ROW($A$6:$A$13)-ROW($A$5))),)) This Issue: However...

I need to match a value in an array to a value in the first row. See Below: <tbody> Medical Dental Voluntary Voluntary (2) Voluntary (3) Voluntary (4) Medical Dental Pediatric Dental Basic Life AFLAC STD LTD </tbody> <colgroup><col><col><col><col...

I have two rows of data the top row is either a number or a blank The next row is a date, when the number was entered This is carried out by the 1st date being the project start & then all the other dates +7 days. I have some vba that takes the date that the update is carried out on (always...

I really enjoyed your tutorial on Excel Reverse lookup (https://youtu.be/mIht6gICsS4) but Im wanting to convert it from a function to a Sub Routine and getting HEAPS of erros {its obvioulsy not just a matter of removeing Function() and replacing with Sub()}. Is anyone able to assist with this...

TAB1 has various data across from column A-J. In Column A, i have a date and in Column J i have the same date plus 7 days with a whole load of other stuff in between. In TAB2, i want to select a month in CELL A1 and have the lines below show the data from TAB1 where the date in Column J falls...

Hi, I have this data: 12345FDEYes 11-5 12345 FDE (Blank) Yes 15140 1 1.0000 3851 12345FDEYes 11-5 12345 FDE Outbound Yes 15141 1 1.0000 3852 That's 2 rows 11 columns (real spreadsheet has 15k+ rows). Rows are almost the same, but you see in the last column to the far right there's one...

Hi, Is it possible to search in a array from bottom cell to top cell (Vlookup does from top to bottom), In the below table I need a result of "Shaft" for input 3, whereas vlookup will give "Crank shaft" as a result <tbody> Level Part 1 Truck 2 Engine 3 Crank Shaft 3 Cam Shaft 3...

Reverse Column and Row Look-up <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> We have been working all day on a very large cataloging file. <o:p></o:p> We want excel to point to the ROW and COLUMN location by searching a RANGE. <o:p></o:p> EXAMPLE...