Help Please IF & VLOOKUP Returns

Closed
nsingers Posts 1 Registration date Tuesday October 13, 2015 Status Member Last seen October 13, 2015 - Oct 13, 2015 at 06:52 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 16, 2015 at 01:37 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 16, 2015 at 01:37 PM
if multiple values are returned how they will show in one cell?
0