| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
look up tables and IF statements
=VLOOKUP(G2,$C$30:$F$369,2)
I have managed to create a look up table using the office assistant, and the formula above dumps information into cell G3. If G2 is empty or has a zero I don't want G3 to have anything in it. At the moment it just keeps coming up with #N/A Can anyone tell me what formula I should be using please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
| How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
| How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
Threaded Mode
