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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 16, 2015 at 01:37 PM
rizvisa1 Posts 4478 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
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
Related:
- Use the ifs function to return 5 if cell a5 contains the value 3
- Gta 5 download apk pc - Download - Action and adventure
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Bluestacks 5 - Download - Android emulators
- Forza horizon 5 download free - Download - Racing
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 16, 2015 at 01:37 PM
Oct 16, 2015 at 01:37 PM
if multiple values are returned how they will show in one cell?
