Help Please IF & VLOOKUP Returns

Closed
Posts
1
Registration date
Tuesday October 13, 2015
Status
Member
Last seen
October 13, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,

I'm trying to use the following formula which works however I can have more than one number which is the same e.g( B2 can be in the TOPWE table more than once) I need the return to return the unique information from the TOPWE not just the first one the lookup comes to.


=IF(AND(B2>=O2,B2<=P2),VLOOKUP(A2,Topwe,2,FALSE))

Thanks

Niki

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if multiple values are returned how they will show in one cell?