View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
matt_the_brum matt_the_brum is offline
external usenet poster
 
Posts: 1
Default 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