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 

leoperdia's avatar
leoperdia
Brass Contributor
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 

Mike_in_Apex's avatar
Mike_in_Apex
Copper Contributor
Jun 29, 2023

leoperdia 

I had tried this on the particular version of a spreadsheet that someone had sent me and it didn't work.  It probably was created by a different version of Excel.  I'm using Excel 2016.  When I created my own test and used your answer, it worked just fine.  Thanks for your response.

 

Resources