| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
blanks instead of "0" in vlookup
This is a vlookup:
I am looking up a cell that happens to be blank, but the result of the vlookup is "0." How do I change the O to a blank? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#2
|
|||
|
|||
|
=IF(ISBLANK(vlookup),"",(vlookup))
Replace vlookup with your current vlookup formula. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Patty via OfficeKB.com" wrote in message ... This is a vlookup: I am looking up a cell that happens to be blank, but the result of the vlookup is "0." How do I change the O to a blank? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#3
|
|||
|
|||
|
Hi Patty,
Just out of curiosity - what is the point in searching for a blank cell to return a blank cell? Regards, KL "Patty via OfficeKB.com" wrote in message ... This is a vlookup: I am looking up a cell that happens to be blank, but the result of the vlookup is "0." How do I change the O to a blank? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Question. | Excel Discussion (Misc queries) | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| Array Function with VLOOKUP | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
