Previous Topic Next Topic

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
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
Related:

1 response

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

Similar discussions

Excel function question
1234ah -
ac3mark -

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses