| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP VALUES
I have a ranking sheet and have determined who moved forwards based on this
weeks/last weeks position using large,cellrange,1 but when using lookup to put a name to number it returns a person with 0 value, by omitting this person i can get the result that i want, but how do i get lookup to ignore 0 values? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LOOKUP VALUES
=if(vlookup(a,b,c)=0,"",vlookup(a,b,c)) -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=524763 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
| How do I use Lookup to return a row of values eg. 6 cells | Excel Worksheet Functions | |||
| Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
| How do I lookup data with two comparison values? | Excel Worksheet Functions | |||
| vlookup using two lookup values? | Excel Worksheet Functions | |||
Hybrid Mode
