This may be a relatively simple fix but it is giving me issues. Please see cell E12 on the attached spreadsheet. I am simply trying to make an HLOOKUP formula work. What am I doing wrong???
-Savage
This may be a relatively simple fix but it is giving me issues. Please see cell E12 on the attached spreadsheet. I am simply trying to make an HLOOKUP formula work. What am I doing wrong???
-Savage
Your HLookup formula is looking for the value "State" in row 13, columns E to W; however, you have cell addresses in those cells for some reason (?). So the lookup value will never be found. Notice that you then say that, if found, then go down to row 3 of the column "state" was found in; but, the array only has two rows vis. 13 & 14.
Explain in words what you are aiming at.
Ben Van Johnson
I am trying to create a search within the data in the table and the box 2 cells below the search will allow me to switch which column the search box is searching. I am following the YouTube video at this link:
https://m.youtube.com/watch?v=EjZ7jE9iL0U
Thanks for the help!
-Savage
C7 is a data validation list of names in column J.
C9 is data validation list of the headers in E14:W14.
In the attached, the formula:
searches the columns across the top row (#14) of the data table E14:W29, for a match to the value in cell C9.Please Login or Register to view this content.
Match returns the ROW of the name in column J that matches that in C7.
So, finally HLOOKUP returns the data at the intersection of found column and found row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks