IFs with IFNA and a vlookup

[b19upj]

Hi,
I think this should be a simple one but it doesn't seem to be working for me.
There is a list of numbers in column A. On the next tab there is a list of the largest 5 numbers from Column A.
The largest 5 numbers are in column D. Next to each of them (in column E). I want to write "Exp" if the number came from the previous tab Column A rows 9-108 and "Inc" if the number came from the previous tab Column A rows 111-160. If nothing is listed in Column D (ie there were only 3 numbers so no largest 4 or 5th place), then instead of NA, leave blank.
I hope that is clear but am unsure if it is.
My formulae that isn't working is:
=IFNA(IFS(Vlookup(D1,'Prev tab'!$A$9:$A$108,1,FALSE),"Exp",Vlookup(D1,'Prev tab'!$A$111:$A$160,1,FALSE),"Inc",),"")

TIA

 

[Fluff]

Duplicate to: lookup number and enter a word depending on row range number was found

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.