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