| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup giving #N/A
I'm using a formula =VLOOKUP(C10,Labour!$A$3:$L$12,HLOOKUP(A10,Labour! $B$1:$L$2,2,FALSE),FALSE) To find a value in a table from two drop down menus. If the are no values in the drop down menus (ie C10 or A10) then the cell reads #N/A. This is messing up the rest of my spreadsheet so I need it to be a blank cell if A10 or C10 are blank or overwritten. Any help gratefully appreciated. -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567885 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| Vlookup and "-" negative numbers are giving me a #N/A | Excel Discussion (Misc queries) | |||
| VLookup in VBA giving error message | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Threaded Mode
