Forum Discussion

Mike_in_Apex's avatar
Mike_in_Apex
Copper Contributor
Jun 28, 2023
Solved

Lookup

I have a location number.  I have an array of results for certain locations.  I want to look up for any results for a location and if so put the results in a cell, otherwise I want to put the value "...
excel
mtarler's avatar
mtarler
Silver Contributor
Jun 28, 2023
If you have excel 365 then use XLOOKUP and it has the if_not_found parameter. If not then probably IFERROR( VLOOKUP(...), 0)
  • Mike_in_Apex's avatar
    Mike_in_Apex
    Copper Contributor
    Jun 29, 2023
    I am using Excel 2016, but the spreadsheet in question which was sent to me may have been created in Excel 365, so "my" solution didn't work. Thanks for your response.

Resources