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
  • leoperdia's avatar
    leoperdia
    Jun 28, 2023

    Hi Mike_in_Apex  this function should work =IFNA(VLOOKUP(lookup range;lookup value;result column;FALSE);0)

     

    Regards

    https://www.upwork.com/freelancers/~01cf0fc8446b00f44c 

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