Forum Discussion

RobMac14's avatar
RobMac14
Copper Contributor
Feb 18, 2022
Solved

VLOOKUP, INDEX and MATCH - can't get them to work

Hi, I'm trying to set up an automatic query that when a code is entered a data dump of information is searched to find the risk ratings for that code in 3 different counties.  The data dump will be ...
excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    Feb 18, 2022

    RobMac14 

     

    You could try this, if you don't have office 365, then you'll need to hit Ctrl+Shift+Enter after keying into the formula bar:

     

    =INDEX('County Data Dump'!$H$2:$H$1846, MATCH(1, ('County Data Dump'!$D$2:$D$1849=$B3)*('County Data Dump'!$B$2:$B$1849=C$2), 0))

     

     

RobMac14's avatar
RobMac14
Copper Contributor
Feb 21, 2022
Thanks for your reply Peter. I've not used the FILTER function before I will explore it further. Thanks for taking the time to reply.

Resources