Forum Discussion
Lookup in an array
Hi, I'm trying to determine if the partnumber on the 2nd tab (column1) has a substitute partnumber in the array on the first tab. On the 2nd tab, The formula should return yes or no in one colum...
Hi Pranav,
Thanks for replying. Unfortunately, the dataset provided is part of a larger workbook with links to the data that you converted to Text. I cannot convert the data to text because that would destroy other links.
So, can you propose another solution with the data being numbers?
Look forward to hearing from you,
Quinn
Is it possible to use Text to column in $A:$A Substitute Partnumbers Isuzu and remove " ' ", if yes, then
can apply
=IF(ISNUMBER(MATCH(A2,'Substitute Partnumbers Isuzu'!$A$3:$A$3172,0)),"Yes","No")
in range V2:V9 , Sheet 2.
Thanks